Jump to content


Photo

computer inventory list with pictures?


  • Please log in to reply
2 replies to this topic

#1 Ann E. V.

Ann E. V.

    Newbie

  • Members
  • Pip
  • 6 posts
  • Locationohio

Posted 03 January 2013 - 11:15 PM

I have an inventory of all my work in an excel program on the computer. It saves lots of time, when work is moved from one gallery to another, so I know where each piece is until (and even after it's sold. I would like to include a picture of each piece as a part of this inventory identification so that the person who updates my website could easily add or substract each item as it is sold or created. Does anyone know of a practical way to accomplish this?

#2 Pres

Pres

    Retired Art Teacher

  • Moderators
  • 1,898 posts
  • LocationCentral, PA

Posted 04 January 2013 - 09:20 AM

I have an inventory of all my work in an excel program on the computer. It saves lots of time, when work is moved from one gallery to another, so I know where each piece is until (and even after it's sold. I would like to include a picture of each piece as a part of this inventory identification so that the person who updates my website could easily add or substract each item as it is sold or created. Does anyone know of a practical way to accomplish this?


Use the Insert/picture/file command to insert the picture into the spreadsheet. Re-size it to fit your space and place it where you want. Pretty simple and straight forward using the resize buttons on corners push the shift down to keep it in proportion.

This should do the job for you pretty quick-great idea on the spread sheet.

Simply retired teacher, not dead, living the dream. on and on and. . . . on. . . .                                                                                 http://picworkspottery.blogspot.com/


#3 JessicaGrayCeramics

JessicaGrayCeramics

    Member

  • Members
  • PipPip
  • 12 posts
  • LocationFeltwell, United Kingdom

Posted 26 January 2013 - 05:30 AM

If you're really zealous about tracking, you can shape it into a marketing tool. I use a similar sheet to track my inventory and who buys it. It's useful to send out emails to your customers when you're doing shows and sales and when you have a piece you think they might like.
Jessica Gray, MFA
www.JessicaGrayCeramics.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users