Fraud Blocker

Clarity Connect integration

Shopify Sage 300 Integration

Send Shopify orders into Sage 300 Order Entry and keep the store's prices, stock and shipping status matched to what Sage 300 records.

Shopify and Sage 300 kept in sync through Clarity Connect

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.

Storefront

Shopify

Checkout, catalogue and customer accounts

  • Orders
  • Customers
  • Product variants
  • Refunds
Clarity Connectreal time or on a timer
ERP

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.

ShopifySage 300Direction
OrderOrder Entry order (OE/OEOrders)Shopify to Sage 300
CustomerAR customer (AR/ARCustomers)Both ways
Product variant (by SKU)Inventory Control item (IC/ICItems)Sage 300 to Shopify
Variant priceItem pricing (IC/ICItemPricing)Sage 300 to Shopify
Inventory quantity at a locationItem quantity at an IC locationSage 300 to Shopify
Fulfillment and trackingOrder Entry shipmentSage 300 to Shopify
RefundCredit 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.

Book a demo

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.

How a Clarity Connect project runs
  1. Discovery

    A Clarity business analyst documents the data fields and workflows each system can share and which ones you need.

  2. 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.

  3. Testing

    Orders and updates are run end to end, including the return trip of statuses back to the customer-facing system.

  4. 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