🤲 Keep Consignment and Sale-or-Return Straight

I take stock on sale or return from local makers and settling up is a nightmare. Build me a consignment app. Keep consignors with their contact details, agreed commission rate and payment terms. Every consigned item records the consignor, the description, the agreed retail price, the date received and its status of In Stock, Sold, Returned or Written Off. Never include consigned stock in my own stock value. When an item sells, attribute it to the consignor at that moment and work out my commission and the amount owed to them. Produce a settlement statement per consignor per period listing items sold, the retail value, my commission and the amount payable. Add an AI agent that drafts each settlement statement with a short covering note, and that tells me which consignors sell through well and which items have been sitting unsold long enough to return. Automate two things: a scheduled monthly settlement run, and a notice to a consignor when an item has been unsold past an agreed period. Two logins: staff who receive and sell items, and an owner who settles and sets commission rates.