Google Sheets Inventory Dashboard

I’d like a clean, easy-to-maintain Google Sheets file that lets me keep tabs on both my physical and digital products in one place. It has to:

• Track current stock levels automatically as I add purchases or record sales
• Flag items that hit predefined reorder points so I can act before I run out
• Generate clear weekly and cumulative sales reports I can share with my team or export for accounting

I update inventory every week, so the sheet should be structured for quick bulk entries (CSV import, simple data-entry form, or another lightweight solution you suggest) and minimal manual formulas on my end. If a bit of Apps Script or connected pivot tables helps keep the workflow smooth, include those pieces inside the same file—no external tools needed.

Please deliver the fully formatted Google Sheet plus brief setup notes that show me where to paste new data and how the reports refresh.