Luminous Landscape Forum

Equipment & Techniques => Pro Business Discussion => Topic started by: luxborealis on December 30, 2013, 10:59:58 am

Title: Suggestions for a database to keep track of photos printed/sold
Post by: luxborealis on December 30, 2013, 10:59:58 am
I am selling more and photographs (fine art prints) and I am hoping those with more experience might be able to recommend a database or other system for keeping track of what's on hand and what's been sold and to whom.

Maybe I'm being too obsessive, but I like to keep track of not just who has purchased my work, but also which edition of each photo(s) they purchased. Does anyone out there have an efficient electronic system that works on a laptop and iPad? I could keep a binder of pages, but it just seems more efficient to keep it digital using a database app.

Your thoughts & experiences?
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Josh-H on December 31, 2013, 02:37:28 am
Personally, I have just been using Excel. However I recently changed over to Apple's Numbers for this as it is iPad compatible and auto syncs with other devices.

No need to overly complicate tracking print sales - a spreadsheet does just fine.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: john beardsworth on December 31, 2013, 05:37:03 am
I'd go with Excel too.

In the past I did write an Access database and connected it directly to the Lightroom catalogue via ODBC. If you have those kinds of skills, you'd avoid a lot of data entry and resulting errors, and you could build up reporting features, for instance.

An in-Lightroom alternative would be to create a virtual copy for each sale. You've got fields like virtual copy name, job and instructions which could contain some of the info you want to record. If you want to go a bit further get your hands a little dirty, it's not difficult to create your own plug-in with some custom fields - look up my BigNote plug-in and customise it.

John
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Isaac on December 31, 2013, 12:44:54 pm
No need to overly complicate tracking print sales - a spreadsheet does just fine.

Yes, even a simplified spreadsheet like Google Sheets (http://www.google.com/drive/apps.html).
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Mike Guilbault on December 31, 2013, 09:56:33 pm
I like your in-Lightroom alternative John!  Might give that a try.  I suppose one could stack the Sale images together to keep it neat.
Title: what kind of fields, categories, forms etc?
Post by: msongs on January 01, 2014, 01:46:26 pm
tried playing with excel a few times. My problem is setting it up, what categories, how to do it by size/name of image? all that sort of stuff. right now I use paper pen and the old slash marks method. when my tax lady asks how much inventory I have I just smile and say "some"
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Justan on January 01, 2014, 02:39:11 pm
Good suggestion, luxborealis. I will give this some thought, as my needs continue to increase and the current system has some shortcomings. Currently I use an Excel workbook with multiple pages, an Outlook contact list, a paper notebook, and a MS Word to do list.

One spreadsheet page is for works printed and this is used to keep track of the print production numbers. All my works are numbered editions and I update this list after each printing cycle.

One spreadsheet page sheet keeps track of each work sold at each show. This tracks what sold by show, by image name, by media used. This is by-far the most useful as when it comes time to plan for future shows it helps me maintain a manageable inventory.

One spreadsheet page is for custom orders that is updated at the time I invoice for the works. These are the only works for which I request name and related info from the customer. I keep each work order on paper and it would be easier to keep track of this stuff if it was all in a DB.

I also keep a paper notebook out at my shows for people who want to sign up for my newsletter and for their recommendations/suggestions. When people recommend something, which happens a lot, I note the details in this notebook. After each show, I copy the email information to an Outlook Contact list. I get between about 70 and 200 new email addresses per show and anywhere between 5 to 20 or so recommendations. The problem with a notebook is that some people have worse hand writing than me and some addresses are illegible. Some recommendations are quite good and those get posted into a MS Word based to do list.

I could probably write a DB that would consolidate all of this. It would be useful to offer free passes to previous buyers of custom works, for example, make the to do list easier to manage, make the custom orders easier to track, make email addresses more readable. Doing so is currently more work than i have time for, but of course as the business moves along, it is difficult to keep track of everything. It helps (or hinders, depending on how you look at it) that I’ve been using Excel to keep track of my other business for so many years that the use of Excel is a natural to me.

Again, a good suggestion. Given a chance to write the key elements down (above), gives pause to see where a better job could be done. Another reason would be to keep better track of supplies....
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Eric Myrvaagnes on January 01, 2014, 08:31:53 pm
A nice thing about a spreadsheet is that it is so easy to add either rows or columns wherever you want as you think of items you forgot to build in at first.

It's also easy to sort instantly on any column on a page (but be careful to select the whole page first, or you'll mess up the rows).
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: bretedge on January 02, 2014, 08:20:01 am
We've been using an Excel spreadsheet since we opened the gallery and it has worked fine.  Our sales volume is getting to the point where we'll need to look at another alternative soon, though.  We're considering Filemaker Pro for a number of reasons, but primarily because it offers the ability to do several things we need to do: keep track of customer information, physical inventory and print sales, for starters.  It isn't cheap but it may be something to consider.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: luxborealis on January 02, 2014, 10:33:46 am
We've been using an Excel spreadsheet since we opened the gallery and it has worked fine.  Our sales volume is getting to the point where we'll need to look at another alternative soon, though.  We're considering Filemaker Pro for a number of reasons, but primarily because it offers the ability to do several things we need to do: keep track of customer information, physical inventory and print sales, for starters.  It isn't cheap but it may be something to consider.

I am also considering the FMPro alternative. I've worked with it in the past and had excellent results, but the reinvestment is a bit steep. It does have iPad integration, though, which will become more helpful over time.

Is anyone out there successfully using a database the has desktop/laptop and iPad integration?
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: bretedge on January 02, 2014, 10:42:16 am
I am also considering the FMPro alternative. I've worked with it in the past and had excellent results, but the reinvestment is a bit steep. It does have iPad integration, though, which will become more helpful over time.

Is anyone out there successfully using a database the has desktop/laptop and iPad integration?

We use the iPad as our cash register with the Square app, although we're not using Square to run the credit cards.  FM Pro's iPad integration is a pretty significant bonus for us.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: rgs on January 09, 2014, 12:59:21 pm
Although I know it's very popular for simple data collections, I don't like Excel spreadsheets. One mistake during a search can corrupt your data. If you're on a PC, take a look at the simple MS "Photo Gallery" that ships with Windows. It allows you to access your photo (including RAWs) and tag it with all kinds of useful information. You could use the "descriptive tag" to make extensive notes if needed. I suspect MAC has a photo gallery with similar capabilities.

If LR or Photo Gallery can't be made to work well enough for your needs, then I think you need a real database. FileMaker Pro is the most user friendly one but MS Access is probably more common. Either one will do about the same thing once you have learned them and, if you can make LR and PS work, you can learn a database. Just jump in and do it. 

FWIW
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: PeterAit on January 09, 2014, 04:59:11 pm
Although I know it's very popular for simple data collections, I don't like Excel spreadsheets. One mistake during a search can corrupt your data.

Searching in Excel does not corrupt data - really! But, Excel is not that easy or intuitive a program. I would not recommend it for anyone who does not already know it - but if you do, it can do a great job. I would use it - if only I had some sales to track!
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: LesPalenik on January 09, 2014, 06:02:40 pm
To paraphrase the old saying - if your only tool is Excel, you tend to look at everything as spreadsheets.
The engineers (I used to be one myself) find it easier to think in rows and columns, but the real-world applications are typically more dimensional.
 
Filemaker or another free form / variable field and record length database would be a much more flexible tool for such an application. Each photo may require different kind of notes, print batches, etc. The initial setup will be for sure more complicated than for a standard Excel spreadsheet, but if it is an application for years to come, it would be a much better solution.

 
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: rgs on January 09, 2014, 07:32:14 pm
When using Excel to collect data, one typically works with redundant backups and archived, dated backups because of the possibility of errors. Excel data is easily corrupted. For example, if you sort a column, you will be asked if you want just that column or if you to extend it across all columns in each record. If you answer wrong or carelessly, you will wind up with a single column sorted separately from the other columns in the record. Depending on how large your database is and how difficult it is to reassemble your data, I would call that corrupted.

I toyed with using Excel to keep track of my stock photos. I could not find an easy way to automatically (or even semi-automatically) put image thumbnails in the cells without having to key in each one manually. That's when I tried the MS Photo Gallery and now I am just using LR collections. If it gets more intensive, I will use FileMaker Pro.

Excel is good for data initial data collection in a work-group because almost everyone knows it or can figure it out. But, once you have your data, you need a real database to work with your data.
 
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Josh-H on January 10, 2014, 04:16:51 am
Just as an alternative to Excel - if you are on a Mac; the new 'numbers' program is simple, easy to use and auto syncs across iCloud to IOS devices.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: john beardsworth on January 10, 2014, 07:16:29 am
When using Excel to collect data, one typically works with redundant backups and archived, dated backups because of the possibility of errors. Excel data is easily corrupted. For example, if you sort a column, you will be asked if you want just that column or if you to extend it across all columns in each record. If you answer wrong or carelessly, you will wind up with a single column sorted separately from the other columns in the record. Depending on how large your database is and how difficult it is to reassemble your data, I would call that corrupted.
....
Excel is good for data initial data collection in a work-group because almost everyone knows it or can figure it out. But, once you have your data, you need a real database to work with your data.
 
You might call it corrupted but it's too strong a term for user error. I agree with your last comments though - if the OP knows how to write a database, that's the way to go.

As I know the OP uses Lightroom, it's a shame that it's not easy to extend in this direction and keep all the data together. Virtual Copies can help, but only at the cost of cluttering up your catalogue with Virtual Copies. I've seen some people use keywords to record sales, but then you're cluttering up keywords with information that doesn't belong there. You can make such methods work, but they are sticking plasters rather than real solutions. A database like Lightroom should allow the user to add custom fields, but it doesn't make this at all easy (Aperture does) but in LR they are pretty limited - a single text value for the field - and you can't set up one-to-many data that's needed in this case where each photo has multiple sales records. You'd have to write a full-blown plug-in for that, or develop something externally.

Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Justan on January 10, 2014, 08:50:53 am
I am also considering the FMPro alternative. I've worked with it in the past and had excellent results, but the reinvestment is a bit steep. It does have iPad integration, though, which will become more helpful over time.

Is anyone out there successfully using a database the has desktop/laptop and iPad integration?

What would you use as a web server platform with FileMaker Pro or does it require that?

The complexity of running a database across the internet goes up substantially. In comparison, with Windows platforms you can use SQL server+ a web interface, MS Office 365, SharePoint, ms Visual Web Developer. None of these are exactly trivial to work with.

You can use MS Access on an ipad but would require some of the above on the back end, plus remote desktop on the ipad. Very cumbersome any way you look at it.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: rgs on January 11, 2014, 01:06:11 pm
One database not mentioned yet is LibreOffice Base. I've just been playing with it a bit and it looks promising. It's very tightly integrated with the rest of LibreOffice and, like all of the LibreOffice suite, it is free. It also seems very user friendly.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Jeremy Roussak on January 11, 2014, 01:54:12 pm
I use 4th Dimension for a variety of tasks. It's hugely competent, but may be overkill.

Jeremy
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: markdauber on January 14, 2014, 08:52:58 am
You might want to take a look at a system I am experimenting with.  www.artcld.com  So far, I'm encouraged.  They offer a free trial. I'm thinking to use it to help manage my gallery and my work.  Check it out.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: bill t. on January 14, 2014, 03:24:08 pm
You might want to take a look at a system I am experimenting with.  www.artcld.com  So far, I'm encouraged.  They offer a free trial. I'm thinking to use it to help manage my gallery and my work.  Check it out.

That's very interesting.  One of the biggest complaints I hear from gallery owners is "computer work" and how surprisingly difficult it is to find employees who are both good salespeople and have the necessary skills to handle databases and spreadsheets and websites.  For those guys, simplification and casting of tasks in familiar terms is good.  I think you will do well.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Justan on January 14, 2014, 04:10:17 pm
^it does look good but I suspect many will back away at $99 per month even if it includes no cost credit/debt card processing.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: David Cordner on January 28, 2014, 07:27:13 am
I have just purchased  Tapforms http://www.tapforms.com Works on Mac, iPad, iPhone and syncs between them. Look a bit like Bento with maybe a few more features. Still early day though.

David
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: luxborealis on January 29, 2014, 10:02:12 am
This is one of the options I've been considering and would be most interested to hear your views on how well it integrates a client database of names and addresses with a works database of finished prints.
-Terry
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Deardorff on February 02, 2014, 10:25:09 am
A 3x5 or larger card file. A notebook.
Give each print an ID number. (and name if you like)

Write on the card or in the notebook the number of prints made and any sales. Also any exhibits they have been in.

Simple, clean and the system does not crash.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: jferrari on February 03, 2014, 01:41:03 am
A 3x5 or larger card file. A notebook.
Give each print an ID number. (and name if you like)

Write on the card or in the notebook the number of prints made and any sales. Also any exhibits they have been in.

Simple, clean and the system does not crash.

Does anyone out there have an efficient electronic system that works on a laptop and iPad? I could keep a binder of pages, but it just seems more efficient to keep it digital using a database app.

Since the OP wanted an electronic system I would assume that he would eventually like to run queries and reports. Tough to do with paper. I'm using MS Access for my application but I have no idea if it would run on an iPad.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: KirbyKrieger on February 04, 2014, 06:28:48 pm
I like your in-Lightroom alternative John!  Might give that a try.  I suppose one could stack the Sale images together to keep it neat.

I do this in Aperture.  When an Image is ready for sale, I color-code it blue (these labels show in the Image Browser, and are even retained in the OS file system when a new file is created by exporting from the database) and add a custom metadata field containing 10 lines.  I sell my fine art prints in editions limited to ten, and simply put the buyer's name on the line with the number in the edition of the purchased print.

I put all buyers in my Contacts program (an electronic Rolodex that comes with Apple computers), and flag them to show in my "Buyers" sub-list.

I have a Smart Album in Aperture that shows Images with Blue labels that are not sold-out.  This is my current "For Sale" catalog.

It's not a good system if you are selling a lot of prints, but for me it works well.

When I was painting, I set up an Access database and tracked buyers, sales, costs, and lots more.  It was overkill.

As with any data acquisition tool, the better you define your needs at the outset, the sharper your tool will be, and the easier to use.

I don't use Lightroom, but I imagine it has custom metadata fields.  I have set up Aperture Libraries that allow artists to track what's been printed, where it is stored, when it was sold, for how much, and to whom.  The drawback is that one can't use it for arithmetic.  "Total sales?" — no idea.  "How many unsold prints should be in flat-file drawer #3?" — no problem.
Title: Re: Suggestions for a database to keep track of photos printed/sold
Post by: Graham Clark on February 06, 2014, 04:15:26 am
I am selling more and photographs (fine art prints) and I am hoping those with more experience might be able to recommend a database or other system for keeping track of what's on hand and what's been sold and to whom.

Maybe I'm being too obsessive, but I like to keep track of not just who has purchased my work, but also which edition of each photo(s) they purchased. Does anyone out there have an efficient electronic system that works on a laptop and iPad? I could keep a binder of pages, but it just seems more efficient to keep it digital using a database app.

Your thoughts & experiences?

I create versions in Aperture that are red in color, and they are (by default) stacked under the main image.

Then I create a Smart Album which filters the red images and I can see the sold images. What's nice about Aperture (as opposed to lightroom, I use both), is that by pressing "T" I can see the metadata overlay very easily for the purpose of seeing who it's been sold to, for how much and at what size.