Fraud Blocker

Clarity Connect integration

Shopify Sage 100 Integration

Post Shopify orders into Sage 100 without re-keying, and let Sage 100's warehouse counts, prices and tracking numbers update the store.

Shopify and Sage 100 kept in sync through Clarity Connect

What moves between Shopify and Sage 100

Shopify takes the order and the payment; Sage 100 fulfils, invoices and keeps the books. Clarity Connect joins the two so an order exists once, in both places, and the store reflects what the warehouse actually holds.

Storefront

Shopify

Checkout, customers and store locations

  • Orders
  • Customers
  • Inventory by location
  • Fulfillments and refunds
Clarity Connectevent-driven or timed
ERP

Sage 100

Sales orders, warehouses and receivables

  • Sales orders
  • AR customers
  • Items by warehouse
  • Invoices and tracking numbers

Shopify to Sage 100 record mapping

Where most projects start. Discovery fixes the fields, number formats and rules.

ShopifySage 100Direction
OrderSales orderShopify to Sage 100
CustomerAR customerBoth ways
Product variant (by SKU)ItemSage 100 to Shopify
Inventory quantity at a locationQuantity by warehouseSage 100 to Shopify
Fulfillment and trackingInvoice tracking numbersSage 100 to Shopify
RefundCredit memoShopify to Sage 100

How the Shopify sync works

A Shopify order becomes a Sage 100 sales order

Shopify's orders/create webhook tells Connect a new order exists. Connect matches the buyer to an AR customer, adds one if needed, and creates the Sage 100 sales order through SO_SalesOrder_bus, the business object behind Sales Order Entry.

Warehouses mapped to Shopify locations

Sage 100 holds quantities per item and warehouse; Shopify holds them per location. Connect maps each warehouse to a location and sets the counts with Shopify's inventorySetQuantities mutation on the schedule you choose.

Tracking numbers back to the customer

When Sage 100 invoices a shipment, its package tracking numbers can be written to the Shopify order as a fulfillment, which lets Shopify send the customer a shipping update. A Shopify refund can travel the other way as a Sage 100 credit memo.

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

API and version notes

Shopify made its REST Admin API legacy on October 1, 2024, and since April 1, 2025 new public apps must use the GraphQL Admin API only. We write Shopify connections against GraphQL.

On the Sage 100 side, the 2026 release (7.50) is 64-bit only, and the Sage 100 API changes between releases, so we test against the version you run and again after each upgrade.

How Clarity Connect runs it

Clarity Connect is Clarity's integration platform. Between Shopify and Sage 100 it keeps a standing two-way link and runs every flow as its own task, triggered by an event or by the clock. More than 3,000 integrations have been built on it. See it working 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 fast does a Shopify order show up in Sage 100?

As fast as the task allows: the orders/create webhook starts it as soon as the order is placed. Stock going back to Shopify usually runs on a timer instead.

We have several Sage 100 warehouses. Does that work?

Yes. Each Sage 100 warehouse can map to a Shopify location, or several warehouses can be totalled into one location; discovery decides which.

Can Sage 100 stay on our own server?

Yes. Connect runs on your network next to Sage 100 and makes only outbound connections to Shopify.

How is it priced?

Clarity Connect costs $599 a month on SaaS terms, or $15,000 once for a license with no ongoing fees. Bigger projects are priced to scope. See pricing.

Related resources

Connect Shopify and Sage 100

Tell us how orders, stock and customers should flow between your Shopify store and Sage 100, and a Clarity business analyst will document the mapping with your team first. Running other systems too? Browse all Clarity Connect integrations.

Book a demo