I own an art gallery and we have over 30 artists that sell a variety of artwork medium

[artworksperdido]

I'm trying to design an inventory system to organize and account for all of the different artist's sales and get a sales report by the month. The report has to provide at total amount of sales for each artist, with a breakout of the artwork that they have sold.

My question is would setting up categories per artist be the best way to account for each artist?

If anyone has better suggestions, thank you in advance!

[rtfulk · Accepted solution]

I would think setting up each artist as a category would be the best way to do it. You could put their artwork in their category and barcode it, so when you scan the item when it sales it will go to the correct artist.

[rtfulk · Accepted solution]

I would think setting up each artist as a category would be the best way to do it. You could put their artwork in their category and barcode it, so when you scan the item when it sales it will go to the correct artist.

[artworksperdido]

Thank you! I was also thinking of adding variances for each medium such as, Artist 1 as a category with variances to describe the mediums, oil, acrylics, pottery, etc. Do you think that would work?

Thank you!!!!

[rtfulk · Accepted solution]

Here's a thought,  Make the main category the artists name, then do sub categories for Oil, Acrylics, Pottery under each artists. Then when they bring in an item for you to sell say a pottery mug you can create an item with a barcode, assign it to Pottery under the Artists name. example below

Mary 

1.Oil

  * Sunset on the Beach painting

2.Acrylics

 *Sunflowers

3.Pottery

 *Pitcher with blue stripes

 *mug with blue stripes

So Mary will be the Category name

Oil, Acrylics, Pottery will be the sub category

Sunset on the Beach, Sunflowers, Pitcher with blue stripes, mug with blue stripes will be the items assigned to the sub-categories

Doing it this way at the end of the month, you could print out what each artist sells so they would know what to restock.

[Ellie_]

Hi there, @artworksperdido,

Thanks so much for reaching out — your art gallery sounds like a wonderful space, and it's great that you're thinking strategically about inventory and reporting! Using categories to represent each artist can work, especially if you want a simple way to group their artwork and run basic reports, similar to what @rtfulk mentioned.