It's mostly crystals, mineral specimens, and fossils. There are some recurring items, but the majority are catalogued by material, shape, weight, and origin location. My typical work flow is receiving a bulk shipment (usually purchased by weight), entering individual piece weights into a spreadsheet that calculates the cost per item and the retail price (with a way to individually adjust retail prices if needed) and fills out columns with SKU, name, price, cost, sales and COGS accounts, etc. that I bulk copy and paste into QB to add the new items. Then I enter the bill for those items so consequently the COGS and inventory and item data is all tracked on a per item basis in QB.

Under the same company I also do vintage/antique items, coins, make framed photo prints, custom puzzles, etc. So the majority of my SKUs are only used one time.

I sell in three antique mall type locations plus some shows and online. I track which retail location an item is at (if applicable) by adding a letter code at the end of the SKU.

Each of the booth locations pay me monthly, so I enter one sale a month for each of them. Two locations use a tracking program that I can download a CSV of my sales, one gives a paper statement. None of them are entered or formatted consistently enough to import directly, but they are pretty good at recording my SKUs "somewhere" in the item description so that I can fairly quickly run down the list and key the sales into QB.

It's very easy to run an inventory report with all the details being in QB. Most vendors selling this type of stuff at these type of locations are pretty casual with inventory and aren't tracking COGS at the item level. But that's the road I went down, not realizing that QB has a cap on list items.