Sage 50 Shopify Integration
Integrate Sage 50 and Shopify with Storehub.io in Minutes for Automatic Stock, Price & Orders
Sage 50 Shopify Integration in Minutes
Configuring Sage 50 to sync with your Shopify store can be done in minutes, no expensive setup fees or complex code required.
Start syncing price, stock & orders same-day with our 1 day turnaround promise.
Eliminate Shopify Pain Points with Sage 50 Integration
Data syncs from Sage 50 to Shopify every 2 minutes. Never sell at the incorrect price again or products you no longer have stock of.
Time saved manually updating stock and price from Sage 50 to Shopify could be spent growing your business.
Orders raise in Sage 50 from Shopify
Orders placed online will raise automatically in Sage 50 from Shopify, no manually keying in data or errors. Capturing orders manually raises the risk of errors significantly. Introduce 100% accuracy – Storehub.io auto captures delivery address, contact details, shipping costs and delivery notes directly into Sage 50.
Why Integrate Sage 50 and Shopify?
When selling online, a lot of data moves between your accounting software and Shopify store. An integration with Sage 50 and Shopify means you save on manually updating price and stock for thousands of product SKU codes, so you’ll never sell an out of stock item again, or at the wrong price!
Because its a 2-way integration between Sage 50 and Shopify, orders placed online also integrate back from Shopify into Sage 50, meaning there’s no repetitive manual data capturing work or the errors associated with keying in large volumes of data.
You may also add B2B Commerce to your Shopify store via link in your menu tab, enabling multiple pricelist, account customer information and customer-specific discounts to sync from Sage 50 to your Shopify B2B Commerce store.
Once your SDK connection is set up with Storehub.io and Sage 50 syncs, the following information will be available to send to Storehub.io and thereon to Shopify automatically.
- Stock (Stock on hand minus stock on order)
- Price list (incl. or excl. VAT)
- VAT rates
- Product title
- Product description
Bringing the product data in from Sage 50 to Storehub.io is the first step towards integrating with your eCommerce store.
Once this data is in Storehub.io, you can enrich your products with merchandising (add images, gallery images, categories, filter tags, product variables/sizes/colours and more), activate/delete products and flag products to sync to Shopify.
Connecting Storehub.io to your Shopify store is as simple as copy-pasting the API keys from Shopify onto your Storehub.io account. Once completed, Merchandising data will flow from Storehub.io to Shopify and orders will automatically write back to Sage 50 from Shopify and raise as a Quote/Sales Order/Invoice.
If you have an existing Shopify store, and would like to integrate it with Sage 50 accounting data, the following Storehub.io modes are available:
Merchandising on Storehub.io – This mode is used when you want to send product and merchandising data to multiple channels (more than just oneShopify store or a marketplace like Amazon or eBay).
Merchandising on Shopify – This mode is used when you have an existing Shopify store and don’t plan on adding a B2B/Trade store module in the future, or integrating with other marketplaces like Amazon, Takealot.com or eBay. This makes for a much simpler setup process as the user does not have to copy the merchandising information from an existing Shopify store into Storehub.io.
Upon an order being placed on Shopify, Storehub.io is notified and the order is raised consequently in Sage 50. You can determine what order type/document type is raised in Sage 50 (Invoice, Sales Order or Quote) based on the payment method type (i.e payment gateway or cash type order), and if the payment was successful or not (for payment gateway orders only).
Order information raised in Sage 50 contains the following:
- Sales channel order reference number
- Delivery address
- Billing address
- Customer details (name, contact number, email)
- Order line items
- Item prices + VAT
- Item discount % per line item (discount is worked out as a percentage of sale price vs ERP price). All discounts/offers are managed on your eCommerce platform.
- Order comments
- All orders syncing from Shopify to Sage 50 may contain a prefix that you define, like “SHO”0018443 – this helps identify the order at a glance.
Other FAQs
Yes, you may have as many Shopify accounts as you like. Each sales channel will accrue an additional connector cost which can be found on the pricing page.
You can not link multiple instances of Sage 50 to Storehub.io under one profile, but you may register a new account with Storehub.io and connect it there.
All your orders will be saved in the Storehub.io cloud, and as soon as a connection is re-established with Sage 50, your orders will populate automatically.
You may only send one warehouse data set to your Shopify store. If you need to aggregate the stock from multiple warehouses and display it on one Shopify store, you will need to create a master warehouse in Sage 50 and aggregate the stock there before sending it to Shopify.
If you change your ERP/Accounting system, you will need to register a new Storehub.io account and configure it with the new ERP details. It’s easy to export all your merchandising data from one Storehub.io account to another via CSV as all the merchandising information will be preserved.
The Storehub.io billing run commences on or as near to the 28th as possible of every month. This means that your account will be billed from the next 28th payment cycle. Note, that billing does NOT commence only when your website is live, as that is not the function of, or in the domain of Storehub.io.
Yes, you can change the setting from “Retail only” to “B2B & Retail” or “B2B only” and your customer data with multiple pricelists will sync from Sage 50 to enable B2B functionality which can be linked to your Shopify store via a link in the menu.
You pay per connector for your store, so you need to select a data source (in this case, Sage 200 Evolution) and then a sales channel (Shopify ). Each connector falls in to a SKU tier based on the number of products you want to sync.
An example would be:
- $75 ex VAT for Sage Business Cloud data connector 0-500 SKUs
- $63 ex VAT for Shopify sales channel connector 0-500 SKUs
- $38 ex VAT for Takealot.com marketplace sales channel
For all SKU pricing tiers, please view pricing here. Please note, pricing may vary according to territory.
How to Integrate Sage 50 Shopify FAQs
What do I need to integrate Sage 50 and my Shopify Store?
In order to integrate Sage 50 with your Shopify store you need to choose the right software to get it done easily.
Using Storehub.io, you can easily integrate Sage 50 with your eCommerce store by simply installing the Sage 50 sync tool on your Sage 50 server. This will automatically integrate product information through to your Storehub.io account, and thereon to Shopify.
The sync tool runs on the Sage 50 server 24/7 integrating data between Sage 50 and Shopify, with latest inventory stock and price info being key, and also fetching all Shopify orders placed online.
How do I integrate stock & price from Sage 50 to my Shopify Store?
In order to integrate stock, price and orders between Sage 50 and Shopify, we’ll need to connect Sage 50 to Storehub.io.
Click the “Add Data Source” button on your brand new Storehub.io account, and get your unique setup code. This code is installed on the Sage 50 server sync tool. This process will automatically sync through:
Product SKU codes
Stock levels
Price (including or excluding VAT)
Product Units
Once you’ve got all your product date on Storehub.io, you can now push it to WooCommerce.
Linking Shopify with Storehub.io is easy to complete, simply log in to WooCommerce > Settings > Advanced > REST API and create a new API key. This key is copy-pasted into Storehub.io in order for the Sage Business Cloud WooCommerce integration to work.
Is it easy to integrate orders from my Shopify Store to Sage 50?
In order to integrate orders with your Sage 50 with your Shopify store, all you need is your Sage 50 sync tool installed on your Sage 50 server so your data syncs to Storehub.io.
All information required to automatically sync orders from Sage 50 to Shopify is done so automatically, with the following being Integrated from Shopify orders:
- Product SKU
- Tax types
- Discounts
- Quantity
- Delivery & billing address
- Order reference
Everything you need to fulfill your orders in Sage 50 will be sent through from Shopify, including the cost of delivery allocated to your service item in Sage 50
What information needs to be set up in Sage 50 in order to sync to my Shopify Store?
In order to integrate Sage 50 with your Shopify store, you’ll need to ensure the following is in place.
- Cash sales customer: This is flagged as a “cash sales” customer type. This is the customer account that all web sales will be allocated to in your Sage 50 Accounting from Shopify
- Delivery service item: All cost of delivery will be allocated to this service item in Sage 50 on orders/sales documents generated from Shopify
How much does it cost to integrate Sage 50 with my Shopify Store?
In order to pay for the integration cost between Sage 50 and your Shopify store, you need to know how many product SKU codes you wish to sync to/from your Shopify sales channel.
- Pick the “Sage 50” option here on the pricing page
- Pick the “Shopify” sales channel, with the appropriate number of SKUs as well on the pricing page
Can I integrate my Shopify website with Sage 50 and my B2B Store?
If you’re running a retail eCommerce store like Shopify, you can easily add Storehub.io B2B Commerce Wholesale via a link on your Shopify eCommerce store menu.
This means you can accept orders back to Sage 50 from Shopify AND your Storehub.io B2B Commerce store seamlessly.
The key difference is the Shopify retail store orders will go back to your cash sales customer in Sage 50 and the B2B Wholesale store will write back orders to each account customer account.
Am I on the right version of Sage 50 to integrate with my Shopify Store?
In order for the Sage 50 Shopify integration to work, you’ll need to be on V18 or newer of Sage 50 Accounting.
There are key database changes with Sage 50 before these versions, so you’ll want to update anyways to ensure your software stays up to date and also get the latest features and security patches.
INTEGRATE Sage 50 & Your Shopify Store Today With Storehub.io
Storehub.io offers the easiest, ‘quick to implement’ and advanced B2B Wholesale eCommerce and retail Sage 50 integration to WooCommerce, Shopify and more.
- Sync Stock & Price to Your eCommerce Store
- Orders Raise in Your Accounting Software
- Same Day Installation & Sync Setup
- Month to Month Contracts