SmugMug Price List Spreadsheet

JCDaydream

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

ChatKat

Thanks
I'd love a copy of that spreadsheet. If it's Excel, you can email it.

denisegoldberg

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 Scott

I too would like a copy...

Thanx

JCDaydream

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

lizziejane

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

xiaoying

yeah thanks! I've love to have one too
Looking forward to your upload!

Cindy

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!

JCDaydream

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

KBedore

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.

JCDaydream

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.

lisap

Thanks so much for sharing this

JCDaydream

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

justus

Spreadsheet
Thanks ever so much, James! Love your photos too!

pmbpro

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.>

aaronbrown

You rule! Let me also add my MANY THANKS!

PhotoDavid78

I would love a copy!!

pmbpro

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!

PhotoDavid78

pmbpro wrote: »

He posted the link a few days ago further up, on Aug 12, so you can grab it now. It's great!

great, got it

JCDaydream

aaronbrown wrote: »

You rule! Let me also add my MANY THANKS!

Thanks Aaron, glad you can use it.

JCDaydream

pmbpro wrote: »

He posted the link a few days ago further up, on Aug 12, so you can grab it now. It's great!

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.

coffenut

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!

Speakoff

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 Booth

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 Booth

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

joedif

Excellent!!

Thanks so much

PhotosbyKW

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.

---

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.

TonyL

Thanks for the effort and being so kind to share.

Sent from my HTC Incredible using tapatalk

its just jb

Thank you!!
KUDOS!!

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

josweigart

Thanks for sharing. This is great!

jchin

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.