Payment Receipt Export to XML for an External Invoicing System

If requested, admins can be given permission to a facility that exports invoice or payment receipts in batches within date ranges on the control panel. It allows the supply of invoice or payment receipt details as feeds in XML format to be imported into an external invoicing system.

Admins will only need to select a date range and then press a generate button. The facility exports invoice or payment receipt details that meet these conditions:

• Orders without an export batch id, i.e. orders not marked as exported.
• Order total value <> €0, i.e. zero-value orders will be excluded.
• Deleted Order = No
• Payment status 'confirmed' or 'pending'.

In other words, exported orders are marked (they are given an export Batch ID) so they will not be exported again. Zero-value and deleted orders are also excluded from the XML exports.

In addition, the export process generates logs where actions are recorded. XML Export Batch Log might come in very handy if an admin needs to revert an export because they make it in error or if they want to re-export for whatever reason with updated data.

Correspondence between XML fields and Database Fields in this Excel Sheet.