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.
Shopify
Checkout, customers and store locations
- Orders
- Customers
- Inventory by location
- Fulfillments and refunds
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.
| Shopify | Sage 100 | Direction |
|---|---|---|
| Order | Sales order | Shopify to Sage 100 |
| Customer | AR customer | Both ways |
| Product variant (by SKU) | Item | Sage 100 to Shopify |
| Inventory quantity at a location | Quantity by warehouse | Sage 100 to Shopify |
| Fulfillment and tracking | Invoice tracking numbers | Sage 100 to Shopify |
| Refund | Credit memo | Shopify 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.
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.
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 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
