Sector guide
Most online sellers run on Shopify, Magento or WooCommerce with marketplaces alongside and Xero or QuickBooks behind, until orders, returns and VAT outgrow the spreadsheets holding it together. Here is how I would judge the moment and choose ERP for ecommerce businesses.
By Christopher Fagan, Managing Partner, PEF Consulting Partners
Delivered for and alongside
















In this article
The symptom is never the ledger. Xero or QuickBooks keeps balancing long after the business has stopped being manageable, because the pain sits in the gap between the sales channels and the books: stock oversold on one channel while it sits unsold on another, returns refunded in Shopify but still showing as sold in the accounts, marketplace payouts posted as one lump that nobody can reconcile to orders, and a VAT return built from four exports and a pivot table. The question I ask is not how many orders you ship but how many places a person has to look to answer a simple question, such as whether an order can be promised for Friday or what margin you made on Amazon last month.
ERP for ecommerce businesses earns its cost when it becomes the single record of products, stock, orders, customers and money across every channel, so that the website, the marketplaces, the warehouse or 3PL and the finance team read one truth. That is a different ambition from a connector that pushes Shopify sales into Xero. Our guide to ERP versus accounting software sets out the general dividing line; the rest of this article is specific to selling online, where returns, marketplaces, cross border VAT and outsourced fulfilment make that line arrive sooner than most founders expect.
Start with the flows, because every platform claims to do them and the details are where they differ. Products: one master record with variants, barcodes, images and channel specific listings pushed out, never maintained three times. Stock: one pool allocated across channels, with the quantity each channel may sell decided by rule rather than by a morning spreadsheet. Orders: pulled in from every channel with payment, shipping, discount and tax lines intact, so the order the warehouse picks is the order the customer paid for. Fulfilment: tracking pushed back to the channel the moment it exists. Returns: a return against the original order that restocks or quarantines the item, triggers the refund and corrects revenue, VAT and stock in one movement.
Marketplaces complicate each flow. Amazon adds Fulfilled by Amazon stock you do not hold, Fulfilled by Merchant orders you do, fees deducted before you are paid and settlement reports on their own cycle. eBay has its own listing rules, payout timing and returns process. A capable system treats these as channels with their own rules rather than as more Shopify. The specialist connectors show what good looks like. Microsoft’s Shopify connector for Business Central imports orders with shipping costs, gift cards, tips, payment methods, fraud risk and return, refund and cancellation information, syncs stock for chosen locations and brings in Shopify Payments payouts. NetSuite Connector covers Shopify, Amazon, eBay, Magento, WooCommerce, BigCommerce and Walmart, posts shipments and tracking back to the order and processes refunds, returns, cancellations and settlement reports automatically. Acumatica’s native Amazon connector handles both FBA and FBM workflows, and its Shopify connector books returns and exchanges as connected ERP transactions with returned and replacement items tracked separately.
My test for any shortlist is one awkward order: a two line Amazon FBM order, one line returned and partially refunded, with the settlement report reconciled to the penny. If the vendor needs a workaround, so will you, every day.
Selling across borders turns VAT into a systems requirement. For goods coming into the UK, HMRC treats a consignment of £135 or less differently from a larger one. When an online marketplace facilitates the sale of goods that are outside the UK at the point of sale, the marketplace is liable for the UK VAT, charged at the point of sale; it is also liable on goods of any value already in the UK that an overseas seller sells through it, while the overseas seller remains liable for import VAT and duty when the goods first enter the country. Above £135 the normal import rules apply. The same £135 figure is the customs duty relief threshold, and the government announced in the Autumn Budget 2025 that it will abolish that relief, with implementation set for March 2029 at the latest and a consultation on the detail; ICAEW has argued the date is too late to protect UK retailers.
For sales into the EU, the One Stop Shop has applied since 1 July 2021. An EU wide threshold of EUR 10,000 replaced the old national distance selling thresholds; above it VAT is due where the customer is and can be declared through a single OSS registration, and the Import One Stop Shop covers consignments of goods up to EUR 150 imported from outside the EU, the old EUR 22 exemption having gone. Customs changed again on 1 July 2026, when the EU abolished the EUR 150 customs duty exemption for low value consignments and introduced a temporary flat duty of EUR 3 per item, charged by tariff classification and payable by the declarant, running until 1 July 2028 and sitting alongside IOSS rather than replacing it.
The ERP therefore needs tax determination by destination, value and channel, OSS and IOSS reporting by member state, landed cost that includes the new per item duty, and multi currency pricing with exchange differences posted automatically. Test it with a basket sold in euros to Ireland, fulfilled from a UK warehouse, then returned.
Most sellers at this stage have either outsourced fulfilment to a 3PL or run a warehouse that has outgrown a wall of printed pick lists. Either way the ERP must send orders out and take confirmations back without a person in between: order lines to the 3PL or the warehouse app, pick, pack and despatch confirmations with tracking back, stock adjustments and goods receipts flowing to the ledger, and inbound shipments to an FBA warehouse treated as stock in transit rather than as a sale. NetSuite Connector, for instance, sends designated orders to a 3PL and returns shipping and tracking information, and lists ShipStation and Amazon Supply Chain among its logistics connections. Brightpearl’s Shopify listing names ShipStation, Loop Returns and Avalara alongside Amazon and eBay. Linnworks automates order routing, stock replenishment and return processing across channels and claims more than 100 integrations.
Then the money. Card acquirers, Shopify Payments, Amazon and eBay each pay out net of fees on their own timetable, and reconciling those payouts to orders, refunds and fees is where finance teams drown. The system has to match a payout to the orders it covers, book the fees, and leave an exception list short enough to clear before month end. The lesson I took from the £9bn Energy Bills Support Scheme that PEF delivered for Ofgem, BEIS and HMRC transfers directly: reconciliation is designed in at the start or never achieved at all. If a vendor cannot show a marketplace settlement reconciled in the demo, the month end will be yours to do by hand.
Shopify itself keeps growing upwards: in November 2026 its UK plans were £25, £65 and £344 a month for Basic, Grow and Advanced and £1,800 a month for Plus on a three year term, so the front end is rarely the reason to change; the reason is what sits behind it. PEF’s team includes consultants who have led and analysed migrations onto each of these platforms, before, during and after the move, and we sell none of them.
What to avoid. Buying a connector and calling it an ERP, when the real need is one record of stock and money. Letting the agency that built the website choose the back office, because their incentive is the storefront. Migrating product data without cleaning variants and barcodes first, which breaks every channel listing at once. Treating marketplaces as more web orders. Ignoring IOSS, OSS and the EUR 3 duty until the first customs hold. And signing a per order pricing plan without modelling peak season, because November volumes are what you will be billed on.
How to choose. Write down your order volume today and at three times today, the channels and countries you sell in, your returns rate and your fulfilment model, then ask each vendor to run your awkward order, your marketplace settlement and your euro return in the demo with your data. Price the subscription, the connectors, the 3PL integration and the implementation separately, and put the VAT scenarios in the contract as acceptance tests. Our ERP integration and ERP vendor selection pages explain how we run that, we take no commission or referral fee from any platform, and our fees are set out plainly on the pricing page. If you sell in store as well, read our ERP for retail guide alongside this one.
Related reading: ERP for retail, ERP versus accounting software, ERP for distribution businesses, ERP for small businesses, NetSuite pricing in the UK, ERP integration consultancy.
When the problems sit between channels and the books rather than in the ledger: overselling across channels, returns refunded online but still showing as sold, marketplace payouts nobody can reconcile to orders, and VAT returns assembled from several exports. If a person has to open three or four systems to promise a delivery date or state last month’s Amazon margin, you have outgrown accounting software with connectors.
For a single entity, Business Central with Microsoft’s own Shopify connector is hard to beat, because it syncs items, variants, stock, orders, payouts and Shopify POS sales as standard. Odoo is the lower cost alternative. Multi entity or multi currency sellers usually move to NetSuite with SuiteCommerce or NetSuite Connector, or to Acumatica. Brightpearl by Sage suits sellers who want order management and accounting in one retail system.
A proper integration treats Amazon as its own channel: FBA stock is tracked as inventory you do not physically hold, FBM orders flow to your warehouse or 3PL, and Amazon’s settlement reports are matched to orders, refunds and fees automatically. NetSuite Connector and Acumatica’s native Amazon connector both support FBA and FBM workflows, and NetSuite Connector processes settlement reports, refunds and cancellations without manual posting.
The One Stop Shop lets you declare VAT on sales to EU consumers through one registration above the EU wide EUR 10,000 threshold, and the Import One Stop Shop covers imported consignments up to EUR 150. From 1 July 2026 the EU abolished the EUR 150 customs duty exemption and introduced a temporary EUR 3 per item duty, charged by tariff classification and payable by the declarant, due to run until 1 July 2028.
The good ones do, and it should be a selection criterion. NetSuite Connector sends designated orders to a 3PL and brings shipping and tracking back, and lists ShipStation and Amazon Supply Chain among its logistics connections; Brightpearl and Linnworks publish similar fulfilment integrations. Ask the vendor to demonstrate order despatch, tracking return and stock adjustment with your actual 3PL before you sign, not a generic connector.
Ready to run every channel from one record? We help online sellers choose, integrate and go live with ERP independently of every platform and agency, with fees shown plainly on our pricing page.
Book a confidential conversation
Independent, client side help across ERP implementation: vendor selection, project management, testing and go live, health checks and programme recovery, on SAP, Oracle, NetSuite, Dynamics 365, Sage, IFS, Odoo, Epicor, Infor and more. Fees are shown plainly on our pricing page.
Written by Christopher Fagan
Managing Partner, PEF Consulting Partners
Christopher has led systems and transformation delivery for 19 years, including the National Grid separation, the £9bn Energy Bills Support Scheme and the BP Pulse EV charging rollout.
Where next