Skip to content
Book a Consultation
Home / Case Studies / Gafbros
Food Packaging & Catering Supplies · B2B E-commerce (Leicester, UK)

From paper orders to a Merlin-connected trade portal

Magento B2B Portal Development (Build) · Merlin ERP Integration · Sales Rep Portal · Performance Optimisation
The Gafbros trade portal Create Order page, showing a customer's catalogue with pack and case prices
0
Price differences across 29,652 prices checked against Merlin
2 min
Full price refresh, down from 9.3 hours
6,500+
Trade accounts mirrored from Merlin into the portal

Summary

Gafbros is a family-owned food packaging supplier in Leicester, founded by the Gaffar brothers in 1976. It serves restaurants, takeaways, cafes, supermarkets and food service businesses nationwide with its own delivery fleet.

TulipTech built it a Magento 2 B2B portal synced both ways with Merlin ERP (Aptean CCBS), going from kickoff to soft launch in under six months.

The challenge

Gafbros had outgrown its Shopify store. Sales ran on phone calls, WhatsApp and Merlin ERP, which holds 6,500+ customer accounts, multi-tier pricing and years of financial history. Reps had no digital tools and took orders on paper.

No real-time visibility. Reps on the road could not see balances, order history or prices without calling the office.
Manual order entry. Orders placed by reps had to be re-keyed into Merlin, causing delays and errors.
Disconnected pricing. Shopify could not handle negotiated deals, volume discounts and price tiers, so every price lived in two places.
No self-service. Trade customers could not view invoices, statements or balances online.
Scale. Around 1,000 published products across 6,500 accounts meant millions of data relationships that had to stay fast.

Our approach

Merlin owns all commercial data. The portal reads a local mirror, refreshed through Merlin's SOAP API, so pages never wait on the ERP, and a dropped connection or bad reply can never delete data.

We built four connected pieces. A customer trade portal shows each account as Merlin sees it. A tablet-optimised sales rep portal lets reps see what each customer sees. A B2C storefront offers products imported from Merlin, with catalogues by business type. Behind them, the custom Gafbros_Merlin engine runs 26 sync jobs and 37 sync services, writing back through SetOrder and SetDelivery with XSD validation, retry queues and reconciliation.

Each customer's prices are resolved at login using Merlin's full hierarchy: six standard price levels, category discounts and customer-specific deals.

Between May and the soft launch on 14 October 2026 (reps on tablets, pilot customers live), we made 555 commits, merged 180 pull requests and worked through some 190 questions with the client over ten-plus Q&A rounds, while Gafbros set up a new factory.

Key capabilities

Dashboard with credit position and aged debt
Ordering at negotiated pack or case prices
Live order statuses from Merlin
Transactions, statements, payments and proof of delivery
Delivery addresses synced to Merlin
Multi-account switching for franchise groups
Customer filters by rep, location and last purchase
Orders on behalf of customers, including cash accounts
Order confirmations emailed to the office
B2C storefront with Dropbox image sync

Technology, security and compliance

Magento 2.4.8 Open Source on Cloudways, with a custom module of 481 PHP files and 51 templates. Customers and reps have separate logins, and daily backups are kept for two weeks. A rehearsed go-live switched from training to live data in two to three hours.

Magento 2.4.8 Open SourcePHPMySQLMerlin ERP (Aptean CCBS)SOAP APIXSD ValidationCloudways

See it in action

One trade order, start to finish.

Select an account: one login across a group's accounts
Create Order: the customer's own catalogue and agreed prices
Review Order: delivery date, order summary and pay on account

Results

Pricing data: 9,118,696 rows down to 17,510 (99.8% fewer), and around 1,150 MB down to 6.9 MB
Price refresh: 9.3 hours down to about two minutes
Price lookup: under 0.1 seconds, where Create Order used to take several seconds
Price accuracy: 29,652 prices checked against Merlin, zero differences

Rep orders reach Merlin within seconds. Customers reorder, track orders and download invoices and statements without calling the office. Data stays current: orders every 30 minutes, invoices every four hours, despatches nightly and portal orders instantly.

Humza Gaffar on the sales rep portal: "The workflow and the process seems a lot better, more simplified. That's the main thing."

Next: a native iOS and Android app, the full B2C launch with payments in December 2026, and the same module for two more clients. The portal price is the ERP price, every time.

Want a result like this?

Tell us where your business is stuck and we will tell you what we would do about it, with numbers where we have them.