How can I take a picture, organize and create a URL for each SKU in a mini-warehouse?

November 7, 2009 6:35 PM

How can I take a picture, organize and create a URL for each SKU in a mini-warehouse?

I have about 150 SKUs that I have organized into a master inventory list in excel. I added a column labeled "Picture URL" where I hope I can put a shareable/accessible URL for someone to view/download to another computer.

I was thinking a good way would be to use Evernote for the iPhone and then title each one the SKU of the item. But Evernote doesn't create a URL that I can use/paste into that field. It just lets me see the picture in a browser within their own system...in other words, I dont end up with http://evernote.com/sample-sku.jpg

I was hoping there was a mobile phone app solution (blackberry or iphone) because I dont care about the pic quality and thinking it would automate the uploading to the web portion...

The other option would be to use a digital camera, but then I would have to look at the picture and then rename the pictures with the correct sku name and then upload it on my server...probably the longest way.

posted by schindyguy to computers & internet (4 comments total)

also, when I view a picture note on evernote.com, "save image as" doesn't use the title I created when I originally took the note, so I would still have to rename it based on what it looked like.
posted by schindyguy at 6:38 PM on November 7

You could use MobileMe, take the picture with your iPhone, you would then send it to your MobileMe account. This picture would be in your gallery with a specific URL. You could also send this picture to your email account which would then create a link you could then copy and paste into your excel spread sheet.
posted by bkeene12 at 7:43 PM on November 7

I dont have mac! Doesnt MobileMe also cost money? Thank you for the suggestion though
posted by schindyguy at 7:57 PM on November 7

Dropbox for the iphone should do this for you.
1. sign up for a dropbox account at getdropbox.com.
2. create a public folder named 'photos' or something
3. get the app (requires 3.1)
4. (I don't have an iphone so I'm not sure of the exact workflow here, but sharing photos is one of the highlighted scenarios)
posted by jacalata at 8:04 AM on November 8