What moves between Shopify and Sage 300
Sage 300 is Sage's ERP for accounting, order entry, inventory and purchasing, the product once sold as Sage Accpac ERP; the current release is Sage 300 2026. It is a different product from Sage 300 Construction and Real Estate, which has its own releases.
In a Shopify and Sage 300 setup, Shopify runs checkout and Sage 300 runs Order Entry, Inventory Control and Accounts Receivable. Clarity Connect carries each order into Sage 300 and brings the ERP's item data and shipment details back to Shopify.
Shopify
Checkout, catalogue and customer accounts
- Orders
- Customers
- Product variants
- Refunds
Sage 300
Order Entry, Inventory Control and AR
- Order Entry orders
- AR customers
- Inventory Control items and pricing
- Shipments and credit notes
Shopify to Sage 300 record mapping
Sage 300 names are the Web API resources Sage documents. Discovery confirms the fields for your company.
| Shopify | Sage 300 | Direction |
|---|---|---|
| Order | Order Entry order (OE/OEOrders) | Shopify to Sage 300 |
| Customer | AR customer (AR/ARCustomers) | Both ways |
| Product variant (by SKU) | Inventory Control item (IC/ICItems) | Sage 300 to Shopify |
| Variant price | Item pricing (IC/ICItemPricing) | Sage 300 to Shopify |
| Inventory quantity at a location | Item quantity at an IC location | Sage 300 to Shopify |
| Fulfillment and tracking | Order Entry shipment | Sage 300 to Shopify |
| Refund | Credit note (OE/OECreditDebitNotes) | Shopify to Sage 300 |
How the Shopify sync works
Orders into Order Entry
A new Shopify order triggers the orders/create webhook. Connect looks up the customer in Sage 300 Accounts Receivable, creates one if it's missing, and posts the order to Sage 300 Order Entry, keeping the Shopify order number on it as a reference.
Item data owned by Sage 300
Items, price lists and stock are maintained in Sage 300 Inventory Control. Connect reads changes on a schedule and updates the matching Shopify variants by SKU, including dated sale prices set up in Sage 300.
Shipments and refunds
Once Sage 300 ships the order, the shipment details can update the Shopify fulfillment so the customer sees tracking. A refund made in Shopify can become a Sage 300 credit note for the accounting team to post.
See Clarity Connect move an order
Watch an online order travel into the ERP and its status come back in our Clarity Connect demo, or book a live walkthrough on your own systems.
The Sage 300 Web API
Sage 300 offers a Web API alongside its web screens: a REST interface built on OData that exchanges JSON, signs in with a Sage 300 user name and password, and addresses each resource by company and module, for example OE/OEOrders. It runs in IIS on your Sage 300 server. Sage still extends it; Product Update 2 for Sage 300 2026 added an Inventory Control manufacturers' item endpoint. The older COM and .NET interfaces to Sage 300's views remain for anything the Web API doesn't cover.
On the Shopify side, the REST Admin API has been legacy since October 1, 2024, and new public apps have had to use the GraphQL Admin API since April 1, 2025, so the store end of the connection is built on GraphQL.
How Clarity Connect runs it
Clarity Connect is Clarity's integration platform. It keeps a two-way connection between Shopify and Sage 300 and runs every flow as a task, live or scheduled. Clarity has built more than 3,000 integrations on it, and has been a certified Sage 300 integration partner and licensed reseller since 2019 (announcement). Demos of other connections are in our video playlist.
Discovery
A Clarity business analyst documents the data fields and workflows each system can share and which ones you need.
Tasks and mapping
Each flow becomes a Connect task, such as orders to the ERP or stock to the store, set to run in real time or on a schedule.
Testing
Orders and updates are run end to end, including the return trip of statuses back to the customer-facing system.
Live, with a dashboard
Queues and scheduled tasks show in Connect's Hangfire dashboard. A job whose target is offline is retried 10 times, every 30 minutes, and can be re-queued once the cause is fixed.
Clarity Connect is sold as a SaaS subscription at $599 a month or as a one-time license at $15,000 with no ongoing fees, and larger projects are priced to scope. See pricing.
Questions
How does Clarity Connect reach Sage 300?
Through the Sage 300 Web API where it covers the record, and Sage 300's views where it doesn't. Connect sits on your network beside Sage 300 and talks out only to Shopify.
Is this for Sage 300 Construction and Real Estate?
No. This page covers Sage 300, the former Sage Accpac ERP. Sage 300 Construction and Real Estate is a separate Sage product.
Can Sage 300 sale prices reach Shopify?
Yes. Item pricing is a Sage 300 Web API resource, so price changes, including ones with start and end dates, can be pushed to the Shopify variants they belong to.
What does Clarity Connect cost?
Clarity Connect is offered at $599 a month as SaaS or as a one-time $15,000 license with no recurring fees; bigger projects get a scoped price. See pricing.
Related resources
Connect Shopify and Sage 300
Tell us which orders, items and customers should pass between Shopify and Sage 300, and a Clarity business analyst will document the mapping with your team before building. For other pairings, see all Clarity Connect integrations.
Book a demo
