Store Audit and Compliance Workflow

Start of the Workflow/Process.

Fetch store details (location, manager, region) from the Store Data Model to populate the audit context.

Create a task for the assigned Auditor to perform the physical site inspection.

Standardized list of items to verify (e.g., Fire Safety, Expiry Dates, Hygiene, Staff ID Check).

Create a new Audit Report entry linked to the specific Store and Auditor.

Update the Audit Entry with the actual start time and completion time.

Fetch the scores from the last completed audit to allow for year-over-year comparison.

Calculate the final percentage score based on (Passed Items / Total Items) * 100.

Sum the total number of 'Failed' items across all stores in the same region to identify systemic issues.

If score is below threshold, automatically create a task for the Store Manager to fix failed items.

Create a new entry in the 'Issues' Data Model for every failed checklist item.

Send an email summary of the Audit results and the Compliance Score to the Store Manager.

Send an SMS alert to the Regional Manager if a 'Critical' safety violation is recorded.

Create a high-level PDF/Dashboard report summarizing all audits completed in the current month.

Update the 'Compliance Status' field in the Store Master Data Model (e.g., 'Compliant', 'At Risk', 'Non-Compliant').

Delete accidentally duplicated audit entries if the system detects a double-submission for the same store/date.

End of the Workflow/Process.