The Challenge

The client, a UK lifestyle and accessories brand, ran sales through three separate Shopify stores: their own website (which also carried orders from multiple marketplaces), a second store linked to their physical retail location via Shopify POS, and a third set up specifically for B2B wholesale. Each store generated revenue that needed to land in the right place in the accounts, but nothing connected them automatically.

Behind the scenes, product costing was even more complex than the sales side. Products were imported from China, split across air and sea shipments, each with its own freight forwarder charges, and actual received weights regularly differed from what was quoted. The true cost of goods sold was being pieced together by hand in spreadsheets, multiplied across three sales channels, which made margin visibility slow and unreliable.

On fulfilment, the client's 3PL handled all dispatch for online orders, which meant stock levels at the warehouse and stock levels in Shopify constantly needed to agree, with no system enforcing that automatically.

What We Built

Dreambits delivered a full Odoo implementation built to unify all three sales channels and bring real costing and fulfilment data into one place:

• Multi-store consolidation: all three Shopify stores, the main site with marketplace orders, the POS-linked physical store, and the B2B store, connected into one Odoo instance.

• Revenue assignment workflow: a custom workflow built to automatically assign sales revenue to the correct accounts based on which store and channel it came from, so the accounting data accurately reflected performance across online, in-store, marketplace, and B2B.

• Real landed cost calculation: replacing spreadsheet-based COGS tracking with a system that accounted for air versus sea shipment splits, variable freight forwarder charges, and the gap between expected and actual received weights, giving accurate, current product costs instead of periodic manual recalculation.

• 3PL stock sync: regular, automated stock synchronisation between the 3PL warehouse and Shopify, so online stock levels reflected what was actually available for dispatch.

The build was carried through to User Acceptance Testing, with the implementation substantially complete and in active client testing against real operational data.

Where Things Stood

We're including that here deliberately rather than glossing over it. The technical build, the three-store consolidation, the revenue assignment logic, the landed cost system, and the 3PL sync, was completed to specification and validated in UAT. What didn't happen was a go-live, because the business itself didn't reach that point. We think that distinction matters, and we'd rather you hear it from us than wonder about it later.

What This Demonstrates

• 
  

• Multi-store, multi-channel consolidation: unifying separate Shopify stores, including a POS-linked physical store and a dedicated B2B channel, into one accounting-accurate system.

• Real landed cost modelling: handling genuinely complex COGS, split shipments, variable freight charges, and weight discrepancies, in place of manual spreadsheet tracking.

• Revenue recognition by channel: making sure accounting reflects exactly where sales actually came from, not just a single blended total.

• 3PL fulfilment integration: keeping warehouse and storefront stock levels in agreement on an ongoing basis.

Talk to Us

If your sales channels, freight costs, or 3PL stock levels aren't talking to each other, this is the exact problem we solve. 

Book a free discovery call and we'll look at your setup honestly, including telling you if Odoo isn't the right fit.