Retail, United States
This USA-based truck parts supplier uses the Magento 2 QuickBooks integration to maintain accurate financial records.
Case Study
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.
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.
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.
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.
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.
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.
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.
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.
This USA-based truck parts supplier uses the Magento 2 QuickBooks integration to maintain accurate financial records.
This Nigeria-based kidswear retailer leverages Webkul’s OpenCart POS system to boost sales, streamline operations, & enhance customer experiences.
AmericanFrame is a leading custom frame and supply company which is dedicated to provide high-quality framing solution uses power BI solution to visualize their website data.
Start a Project
Message Sent!
If you have more details or questions, you can reply to the received confirmation email.
Back to Home