Google Sheets + Apps Script Expert – Custom Inventory System with Category Tabs & Xero Integration

I sell unique one-off mid-century furniture online, at markets and through a partner store. I need a clean, simple system to organise my inventory properly instead of paper records and a half-built Google Sheet. What I need: Master “All Stock” front sheet showing everything currently available Separate linked category sheets (Lighting, Seating, Artwork + others) that auto-update and show only the relevant items Columns: SKU-ID | CAT | Product Name | Description | Image | Purchase Price | Method Purchased | Purchased From | Date | Item Location | Status (SOLD / STOCK) | Sold Date | Seller | Sold Price | Commission Paid | Total Received | Payment Method | Processed Y/N The system should make adding new purchases and marking items sold fast and easy, automatically update stock status, and give me clear visibility. I also use the UK VAT Margin Scheme (though it’s not the top priority right now). Bonus if we can feed the financial data into Xero with a tested live transaction. Deliverables: Fully built Google Sheet with master + category tabs and smart automation Easy data entry + stock status updates Quarterly summary view Short user guide + handover call Xero integration test (if we include it)