Data Reconciliation API - Data Reconciliation Overview
End of Day Reconciliation
When a Site has closed for the day (allowing some time for any remaining transactions to send/process) the integrator kicks off an automatic process for checking and fixing data differences between Site's and Showtime's data.
The "Site Daily Metrics" endpoint is called to return the summary metrics for the site for a specified date. The same summary metrics are generated from the site's local database and compared. If there are differences discovered, the integrator automatically attempts to resolve by reposting relevant transactions.
Discrepency Handling
Ticket/Shop:
Resend all "Orders" for the site for the date.Note: This will clean down all "Orders" and "Refunds"
Customer Points:
Resend all "AccountMovements" for the site for the date.Staff Minutes Worked:
Resend all "StaffAccesses" for the site for the date.StockTake Cost:
Resend all "StockLevels" for the site for the date.Stock Disposal Cost:
Resend all "StockDisposals" for the site for the date.Performances:
Resend all "Performances" for the site for the date.Reconciliation Recheck
Recall the "Site Daily Metrics" endpoint to return the updated summary metrics for the site for the specified data. The same summary metrics are recalculated against the site's local database and compared again. If the differences persist, we send an email detailing the discrepencies to support for manual investigation.
Post Check Results
Once we have completed the process, a report of the output of the data reconciliation should be posted back via the "Site Daily Check Results" endpoint.