Items and inventory

When to add an item

Keep most stock in a lot's pool. Give a piece its own row when:

• You paid a specific price for it.
• It's worth enough that a wrong cost matters: a hit, a graded card, sneakers, a coin.
• You need to know where it is.
• You want to track how long it's sat unsold.

Everything else is bulk, and bulk goes in a lot.

Item fields

A SKU

Yours or generated. It matches the item to a sale when the listing title is messy.

A cost

Typed, or inherited from its lot. A typed cost always wins and imports never overwrite it.

A lot

Where it came from. An item in a lot takes its cost out of the pool, so the lot still expenses only what you paid.

A location

Bin, shelf, box. Print it as a QR label that opens the lot on your phone.

A status

On hand, listed, sold, written off. Drives inventory value and aging.

Import a spreadsheet

Import inventory takes any spreadsheet with a title column. Map the columns once. Rows with an existing SKU update that item.

.csv, .xlsx and .xls all work. A cost you typed in the app stays, even if the sheet is blank there.

Aging

Each on-hand item counts days since you bought it. Inventory aging shows how much money sits in stock that hasn't sold in six months.

If your profit looks fine but your bank balance doesn't, check this first.