Great video. I use a very similar spreadsheet but I'm a little behind in adding my inventory to it! I have a column for tracking if an item is in my booth as I have some inventory in storage waiting for an appropriate season.
I'm always behind too 😅 I should add a column to note where it is! Especially now that the number is getting so high. I've also scrolled the whole list just to remember what I have and knowing if it is at the booth or not would be a big help! Now I'm considering a column for season too since I have some fall things I pulled out a few weeks ago!!
Great video - I'm just getting started and not ready to sell but already collecting. I need to begin keeping an inventory as I've collected quite a bit. The spreadsheet is great but is view only; how do I access it to add my own inventory/name/etc.? Thank you!
Hi, super helpful. I'm just going official booth this next month! Quick question, I see in your amazon link that you have a webcam. Is that something you keep in your booth?
Hi! Very exciting that you're starting a booth next month! It is not, the store I'm at does have cameras, but I don't have one in my booth. I haven't had an issue with theft and my first thought is that I would spend waaaayyyy too much time just watching people shop. It would be a great way to see what's actually drawing people's attention though!
Thank you for sharing, this is what i needed for my new booth! It would be nice to be able to add in the monthly booth rent, stoe 7% commission and calculate it into the profit/loss column. What are your thought on this? Thank you!
Hi! Yes, I do add the percent commission on my personal sheet. I also add in the 3% they charge for credit cards. I just assume everyone will use a credit card then I can be surprised when they do not. The rent is harder to add in because it would need to be divided by the number of things you sold that month, so you wouldn't be able to add it until the end of the month. Hope you're having a blast with your new booth!!
Hi, great inventory video. Can you tell me the name of the POS program the antique mall uses? The owner of the mall where I have a booth is looking for a program to use. Thanks, Trish
I just logged the items as a garage sale so I could keep track of where I was successfully finding things that sell. I'm not sure how this would be officially recorded though.
Happy it was helpful! I account for the cost of the item, any materials like paint or glue to fix it, the 10% that the antique store takes and the 3% I cover if someone uses a credit card 😳 it seems like a lot, but it's only a problem if you don't account for it when pricing your items!
I keep those on a separate spreadsheet sheet. I have a row for each month with overall sales, rent, other fees (vendors pay the credit card fee at our store) and the cost of the product. That way I can subtract all of those things from sales to see the profit. I haven't started tracking millage! I need to do that this year!!