Restaurant COGS Calculator

Main application for managing customers, dishes, ingredients, and calculating COGS with margin analysis.

Track and analyze COGS changes over time with ingredient rate change tracking.

Analyze purchase data, vendor performance, cost trends, and item analysis.

Upload files, configure mappings, and import data from external sources.

Automatically create all required database tables if they don't exist.

Verify database connection and check table structure.

Run database migrations and fix any structural issues.

Import ingredients from MithaasLive$Purch_ Inv_ Line table.

Check the status of ingredient imports and see what's missing.

Run migration to add ingredient rate change tracking features.

Complete documentation, setup instructions, and troubleshooting guide.