Just inherited a photo business and with all the craziness and my day job, haven’t got much time to build a much needed system out, so looking for someone that can help with the following project
System contains interconnected tables for:
photos inventory of different sizes
stores where they are sold (with different terms / some multi-location companies)
inventory in each store
contact list for store owners / workers & individuals
orders from each store
orders from individuals
print queue to produce photos
It’s relative ‘simple’ but time I don’t have…
Essentially the business prints photos that are sold in local stores, also (very limited number of photos are) ordered through a website. Need to track each store’s inventory as the photos are (mostly) sold on consignment (though some are bought outright), so that my wife can easily go to each store, understand what’s been sold so what’s owed, and we can understand popularity of each photo so we can print more for in house stock or in store inventory. Barcode / label and printed report production a plus.
Please reply at simmonet@mac.com
Cheers
