De Kammieshop Improves Order and Payment Accuracy with a Custom OpenCart Odoo Integration by Webkul
- URL: dekammieshop.nl
- Country: Netherlands
- Industry Vertical: Reptile and Pet Supplies Retail
- Platform: OpenCart storefront with Odoo as the back office
- Solution Provided: Custom OpenCart Odoo integration work covering discount sync, payment reconciliation and order traceability.
Merchant Story: De Kammieshop
De Kammieshop is a Dutch online retailer that supplies reptile keepers.
It sells what a terrarium needs, from lighting and substrate to live feeder insects.
The shop stocks brands such as Exo Terra, Zoo Med, Arcadia, Habistat, Lucky Reptile and Pangea Reptile.
Its range also covers birds, fish and dogs, so the shop is wider than reptiles alone.
Live and frozen food animals make up a large share of the daily order volume.
The business sells direct to consumers, and it ships across the Netherlands and Belgium.
De Kammieshop also runs a reward point scheme, and every product page shows the points a buyer earns.
Bundle offers sit alongside it, so one order can carry more than a single kind of discount.
Behind the storefront, De Kammieshop runs Odoo ERP, an Enterprise Resource Planning system, for its back office.
Why De Kammieshop Needed a Custom OpenCart Odoo Integration
Orders already moved from the storefront into Odoo, but the discount side of an order did not survive the trip.
Bundle discounts and redeemed reward points were missing, so the Odoo order total did not match OpenCart.
Tax figures drifted with those totals, and the finance team had to correct documents by hand.
Payments were the second problem.
The shop takes iDEAL, PayPal and card payments through Mollie, and the money rarely lands on the order date.
Because of that timing, a matching attempt that ran too early failed and then stayed failed.
Tracking was the third gap.
Staff answering a customer query knew the OpenCart order number, not the matching Odoo reference.
Finding the right sales order, invoice or bank entry then meant checking several screens.
How Webkul Extended the OpenCart Odoo Integration
Webkul reworked the connector that De Kammieshop already used rather than replacing the setup.
The work covered four areas: discount sync, payment retry, order number search and payment matching.
Each change sits inside the Odoo Bridge for OpenCart that moves orders between the two systems.
How Does the OpenCart Odoo Integration Sync Bundle and Reward Point Discounts?
It reads both discount types from OpenCart and records them in the Odoo order as separate lines.
Webkul changed the order sync to fetch the bundle discount and the redeemed reward point discount.
Because each one becomes its own order line, the Odoo total and the storefront total now agree.
Tax is then worked out on the same base in both systems.
Finance no longer edits an order to explain a gap that the sync itself created.
Automatic Retry for Mollie and PayPal Payment Reconciliation
Mollie and PayPal payments now retry on their own instead of failing after one attempt.
Webkul extended the reconciliation logic so an unmatched payment is tried up to five times.
The reconciliation cron moved to alternate days, which spreads those attempts across about ten days.
Delayed payments then clear without anyone watching the queue.
Anything still unmatched after that window can be reconciled by hand using the storefront order number.
OpenCart Order Number Visibility in Odoo Sales Orders and Invoices
The OpenCart order number is visible on the Odoo sales order and on the invoice.
It already sat on the sales order, so Webkul kept it there and added it to invoices where it was needed.
In addition, the number appears as a column in the list views for both documents.
It also works as a search and filter field, so a single lookup finds the right record.
An agent can move from a customer email to the matching invoice without guessing.
Order Number-Based Payment Reconciliation in Odoo Journals
That same reference now drives payment matching on the accounting side.
Webkul carried that reference through the sales order to invoice flow so it reaches Odoo journals intact.
It shows in journal and list views, and staff can search it there.
Matching uses the bank statement reference that Mollie and PayPal already supply.
As a result, automatic and manual reconciliation both work from one number.
Results of the OpenCart Odoo Integration for De Kammieshop
Order totals in Odoo match the storefront, and delayed payments settle without manual chasing.
Discounts arrive as data rather than as a gap that somebody has to explain later.
Meanwhile, the retry window absorbs the normal delay in Mollie and PayPal payouts.
Finance and support share one reference, and it is the number a customer already quotes.
Webkul’s Odoo development team built each change on the connector that was already in place.
- Bundle and reward point discounts sync into Odoo as separate order lines
- Order totals and tax agree between OpenCart and Odoo
- Unmatched Mollie and PayPal payments retry across a ten-day window
- OpenCart order numbers are searchable in Odoo sales orders and invoices
- Payment reconciliation runs on one consistent order-number reference