Im not sure where to post this but im hoping some of you may have a similar situation. I am taking pics of all the bracelets we make. 1 long way and one circular. then store them in a folder. some will be sold by us but some will be sold at a store. the store uses a naming convention for the product skus and we on our own do not as of yet.
My problem is trying to figure out HOW to keep all the products organized so I know what is at the store, which has sold (i get emails with the skus) and which we have sold Etc without getting all confused. should i use EXCEL or something or organize the images in related folders? Im just at a loss on how to keep track of the items LOL
Thanks for any help!!
If you have the Microsoft Office Suite my suggestion to you would be to use Access, the database that comes with it. There is a very quick and easy tutorial/template that will set you up in no time. But, someone else will come along and suggest Excel. My two cents worth--Access is sooo much easier to set up and use.
I've also seen a few specialty apps geared towards this.
Bead Manager Pro and Jewelry Designer Manager
has anyone used these? whats the consensus on them?
Depends on how big is your collection and how many different selling points you have. If you are selling from a lot of store fronts or just one. for a product selection less than 100, you can manage in excel. If you are planning on expanding to a few hundreds, better use a database. Access come free and can be configured by a novice programmer.
Mall of Style | Fashion Jewelry Store
Whats the tutorial / template? do you happen to have an example accdb i can play with?