An online store retyped every order into its accounting by hand. We worked out how that can happen on its own: a sales invoice for every order. Below, you'll see step by step how that works.
There was no ready-made connection between the online store and the accounting software. All the store could provide was a file of orders.
Five steps. One of them stays manual, and we're upfront about it.
The orders come out of the online store as a file. Someone exports that file and puts it in a folder.
In the file, one order takes up several rows. The system reads the file and groups the rows by order.
It looks up the customer in the accounting software, by email address or by name and postal code. Even when it's spelled slightly differently. If the customer doesn't exist yet, it creates them.
It creates the sales invoice, with the VAT, shipping costs and discount as they appear in the file.
Is anything missing? And has this order been processed before? An order must never become an invoice twice.

Jesse Scherpen worked out the solution. Do you also have two systems that don't talk to each other? This is where it starts.