What moves from Shopware to Exact Online
Each Shopware order becomes one sales invoice in Exact Online. A refund becomes a separate credit invoice, which is a negative invoice that reverses all or part of the original sale. The original invoice stays as it was.
Integrator reads orders from Shopware every 15 minutes, and when you press Run now. Changes made in the last minute before a run are picked up on the next run. Paid orders are booked. Orders whose payment is still open or pending, and cancelled orders, are not booked. A payment state Integrator does not recognise, for example one added by a plugin, is not treated as paid.
For each order Integrator reads the order number, customer, email, billing country, payment status, lines, VAT per line, discounts, shipping, refunds and totals. In Exact it writes the customer, sales journal, a reference to the order, the date, the items with VAT per line, discounts and shipping. When a customer has to be created in Exact, only name, email and country are filled in.
Lines, VAT, discounts and shipping
Every product line is booked against an existing sales item in Exact. A sales item is an article record in Exact with its own code. Products are matched by SKU, so the product number in Shopware must match exactly one item code in Exact. An order with a product that has no matching item stops.
VAT is booked per line, using the rate Shopware actually applied to that line. Integrator picks the Exact VAT code by rate. If your administration has more than one VAT code for the same rate, it cannot choose on its own and you set a mapping from rate to code. For foreign orders, a domestic code is not used just because the percentage matches.
Promotions in Shopware are spread over the product lines they reduced, so each invoice line shows its own discount. Shipping is booked on a separate shipping item you choose in Exact. Shopware often splits shipping VAT over the rates in the order, for example part at 21% and part at 9%. In that case the invoice gets one shipping line per rate.
Before anything is written, the lines after discounts plus shipping must add up to the order total in Shopware. If they do not, the order stops for review instead of being booked on a guess.
Refunds and payments
Shopware itself does not create a refund document. Refunds are recorded by your payment plugin, which can store each refund and the order lines it covers. When those records exist, Integrator books one credit invoice per refund with the refunded items, VAT per line and shipping.
When an order is marked as fully refunded but the plugin left no refund records, the credit invoice mirrors the whole invoice, every line and shipping included. When an order is marked as partly refunded without records, Shopware knows money went back but not how much, so the order stops for review.
Invoices and credit invoices are not marked as paid. They stay open in Exact, and you match payments and settle credits in Exact yourself. Integrator does not finalise, email or delete invoices.
What stops for review or is not followed
Some orders cannot be booked safely yet. They stop with an explanation, and the other orders continue. The cases below are the current limits of the beta.
Changes to an order after it was booked are not followed, apart from refunds. Existing invoices in Exact are left unchanged. If you correct a booked invoice by hand, do not rewrite its lines before a later refund arrives. Integrator checks an existing invoice by its totals, customer, reference and type, so line changes that keep those values are not detected.
- Orders in a currency other than EUR.
- Bundles, surcharges and shipping discounts such as free or reduced shipping promotions.
- A product line taxed at two VAT rates.
- Discounts that cannot be traced to specific lines, or that do not add up.
- Missing, ambiguous or incomplete VAT information, including a VAT code Exact does not have.
- A partial refund your payment plugin did not record in Shopware, or refunded lines worth more than the refund.
- An order that changed while it was being read. Retry after the change in Shopware is finished.
- Products without exactly one matching sales item in Exact.
Set up Exact Online and Shopware first
Integrator uses the sales items and VAT codes of the connected Exact administration. Prepare these before you connect anything. Check them in a test administration first, then repeat the same setup in your live administration.
- A sales journal for webshop sales.
- Sales items in Exact whose item codes match the product numbers in Shopware, one item per code.
- A sales item for shipping, if you charge shipping.
- VAT codes for every rate you sell at, under Stamgegevens, Btw-codes. Decide which code belongs to each rate if you have several codes for one rate.
- How customers are handled: one fixed existing customer, matching by exact email, or allowing Integrator to create new customers.
- In Shopware 6.6 or later, an integration under Settings, System, Integrations with Administrator switched off and a role that may view orders, customers, products, taxes and currencies. Copy the secret key straight away, Shopware shows it only once.
- Your shop's https:// address, the one you open the administration on, without /admin. Exact Online connects through its own sign-in, one administration per connection.
Test safely before turning it on
Connect Shopware to an Exact test administration before your live one. Integrator asks you to validate the integration there before live use.
Then run a dry run. It reads up to 20 recent orders with real data and shows, per order, what would be written to Exact. It writes nothing. Compare what it shows for each order with the order in Shopware.
Pick orders that cover what your shop really does. Ask your bookkeeper to check the VAT per line and the totals, and check how your payment plugin records refunds.
- An order with lines at 21% and 9%, so shipping is split over both rates.
- An order with a promotion on some lines.
- A fully refunded order and a partly refunded one.
- A foreign customer, if you sell abroad.
- Run the same orders again and confirm no second invoice or credit appears.
What to do when an order stops
One stopped order does not hold up the others. Each record shows when it was found, how it was prepared and what Exact answered, and the explanation tells you what to fix. Errors without an approved explanation are shown as not yet explained.
After you fix the cause, send the order again. Sending again does not create a duplicate invoice or credit. If Exact refuses the login itself, the run stops until you reconnect Exact Online.
- VAT code missing: add it in Exact under Stamgegevens, Btw-codes, or change the VAT mapping, then retry.
- Customer, item, journal or VAT code does not match: correct the reference data in Exact and preview again.
- Order needs review, for example a bundle or a partial refund without records: book this order by hand. Ask your Integrator administrator if every order stops here.
- Exact has not confirmed a write: check in Exact whether the invoice or credit already exists before you retry.
- Exact login expired: reconnect Exact Online in Connections.
