Use Cases
The primary reasons merchants integrate Shopify with Sage are: automating invoice creation from Shopify orders, synchronising stock levels between systems, keeping customer records consistent, and generating accurate VAT returns from combined data.
Sage 50 and Sage 200 are the most commonly used Sage products in UK SMEs. Sage Intacct and Sage X3 serve larger businesses. Integration approaches vary significantly by Sage version.
Integration Options
Direct integration apps in the Shopify App Store connect Shopify to Sage. Options include Sage Bridge by Amaka and Connex for Sage. These are simpler to set up but less flexible than middleware platforms.
Integration platforms like Patchworks, Celigo, and Boomi offer more robust Shopify-Sage integrations with greater control over data transformation and error handling. They are more expensive but essential for complex data requirements.
For custom requirements, Sage has an API (varies by version) and Shopify's Admin API allows direct integration development.
Data Mapping
Before integration, document exactly which data needs to flow in which direction. Typical Shopify-to-Sage flows: orders to invoices, products to stock items, customers to sales ledger accounts.
Map Shopify fields to Sage fields carefully. Shopify's shipping address fields map to Sage's delivery address. Shopify's product variant SKU maps to Sage's product code. Mismatched mappings cause reconciliation problems.
Order Sync
Order sync creates invoices or sales transactions in Sage for each Shopify order. Configure whether to sync orders in real time (as they are placed) or in batches (e.g., end of day). Real-time sync is cleaner for financial reporting; batch sync reduces API calls.
Decide which Shopify order statuses trigger sync: typically fulfilled orders only, to avoid syncing cancelled or test orders.
Inventory Sync
If Sage is your system of record for inventory, sync stock levels from Sage to Shopify on a schedule. Any stock adjustments made in Sage (goods receipts, write-offs) automatically update Shopify availability.
Be careful with bi-directional inventory sync: Shopify decrements stock when orders are placed, and Sage decrements stock via goods issues. If both update each other simultaneously, you can get sync loops.
Common Issues
VAT mismatches: Shopify calculates VAT at the product level. Ensure your Sage tax codes match Shopify's tax configuration exactly.
Duplicate customers: When a customer has multiple orders, integrations sometimes create duplicate Sage ledger accounts. Set up matching logic based on email address.
Timing issues: Orders that are refunded or cancelled after syncing need to be handled via credit notes in Sage.
Choosing an Integration Tool
For small volumes (under 100 orders per day), a simple app integration works well. For high volumes or complex requirements (multiple currencies, complex VAT, multi-warehouse), an integration platform gives better reliability and support.
