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 (http://www.jcdaydream.com/stuff/smugmug-pricing-spreadsheet/)

Enjoy

[ChatKat]

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 (http://www.dropbox.com/) 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]

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

[xiaoying]

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

[Cindy]

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

[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 (http://www.jcdaydream.com/stuff/smugmug-pricing-spreadsheet/)

Enjoy :thumb

[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]

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]

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]

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

I haven't upgraded to SmugMug Pro yet, but I see it coming in very handy already! :thumb

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]

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

[PhotoDavid78]

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

great, got it

[JCDaydream]

You rule! Let me also add my MANY THANKS!

Thanks Aaron, glad you can use it.

[JCDaydream]

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

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 (http://www.briandiazphotography.com/SmugMug%20Pricing%20Sheet%20Excel.xls)


BD

[joedif]

Excellent!!

Thanks so much :thumb

[PhotosbyKW]

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 (http://www.jcdaydream.com/stuff/smugmug-pricing-spreadsheet/)

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]

:bowKUDOS!!

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.

[drode]

Another thanks!

This will save me a ton of time.

[Zotz]

This is a godsend. Thanks for selflessly sharing your efforts.

[caseserve]

Thanks for doing this.
I have one quick question...
What is the markup correction if I select Color correct all my images under Bay Photo?

Thanks again!

[mdslngr]

very helpful! thanks for all your hard work!

[wdbrnb]

Thanks so much for taking the time to do what was needed. You have just made my pricing work sooooo much faster and easier.
:barb

[Michaelinitaly]

thanks for sharing this...

[justin24]

Thank You for this :bow

[charlesdaly]

Thanks much JC. I downloaded it but haven't been able to find the time to open because I'm spending too much time on your site, reading about your film life experiences and some excellent shots. My nephew is a director in Canada so I understand.
Cheers. ~ Charles
http://www.charlesdalyphotography.com (http://charlesdalyphotography.com/)

[caseserve]

Is the spreadsheet kept up to date?

Thanks,

[golivas]

Wow, awesome! Thanks!!

[SlightlyPearShaped]

thanks for this :D

[VanguardImaging]

I was using your price sheet when I realized that it doesn't have a way to account for the color correction service through bay photo. Do you have any idea how to enable that? I have been looking at some things, and it doesn't seem as thought they use a fixed percentage for the markup. This will be a hassle if we have to input all the prices, but if you find out that it is indeed a specific price for the color correction based on what you are printing, I would love to work with you and fill in the new prices.

[fauxtoe]

Hey there folks!
I was really happy to find this thread and quickly reminded of how under appreciated DGrin is in my life. Everytime I come here, I ask myself why I don't come more often!

That said - Thank you, in advance for the spreadsheet with pricing....Is there any chance you have this updated with current pricing. The spreadsheet has Bay Photo 4 x 6 lustre for $.25 and it is now $.38. Puts price increases in perspective but I would love to have a new copy!
My email is: bf@brandifitzgerald.com should you want to send it over.

I'd be happy to trade a piece print of my artwork for your time!

Hope you had a great day!

Brandi Fitzgerald
www.brandifitzgerald.com

[The anxious one]

Thank you for the link.

[CurlysGirly]

Is it me and my terrible excel skills? When I open the spreadsheet and make changes to the spreadsheet, the fields in that row don't update to reflect the prices. I am using Microsoft Excel 2011 for Mac. I also saved the file and uploaded it to Google docs but it's still not showing me the prices when I put in a percentage. Hmmmmm....I am so much better at html and css than excel :)

Thanks in advance spreadsheet heros!
Tara