Sage 50 Shopify Config
Syncing data between Sage 50 and your eCommerce store is simple to configure, with no code experience required.
Sync Critical Data To Shopify
Stock, price sync to Shopify from Sage 50 Cloud and all orders that come from Shopify
Orders raise in Sage 50 from Shopify
Orders placed online will raise automatically in Sage 50 from Shopify, no data capturing required.
Once your SDK connection is set up with Sage 50 , the following information will be available to send to Sage 50 Shopify and thereon to your Shopify store store 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 Sage 50 Shopify is the first step towards integrating with your Shopify store.
Once this data is in Sage 50 Shopify, 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 your Shopify account.
Connecting Sage 50 Shopify to your Shopify store is as simple as copy-pasting the API keys from Shopify onto your Sage 50 Shopify account. Once completed, Merchandising data will flow from Sage 50 Shopify to Shopify, so product merchandising, pricing & stock will update automatically.
If you have an existing Shopify eCommerce store, and would like to integrate it with Sage 50 accounting data, the following Sage 50 Shopify modes are available:
Merchandising on Sage 50 Shopify - This mode is used when you want to send product and merchandising data to multiple channels (more than just one Shopify/eCommerce store and/or a Marketplace like Amazon or eBay or Google Shopping).
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 their Shopify store into Sage 50 Shopify sync tool.
When an order is placed on your Shopify eCommerce store, Sage 50 Shopify 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 Shopify.
- Order comments.
- All orders syncing from your Shopify store to Sage 50 may contain a prefix that you define, like “SHOP”0018443 - this helps identify the order at a glance.
Yes, you may have as many sales channels as you like. Each sales channel will accrue an additional connector cost.
You can not link multiple instances of Sage 200 Evolution to Storehub.io under one profile, but you may register a new account with Storehub.io and link it.
All your orders will be saved in the Sage 50 Shopify cloud, and as soon as a connection is re-established with Sage Business Cloud, your orders will populate automatically.
You may only send one warehouse data set to your eCommerce store. If you need to aggregate the stock from multiple warehouses and display it in one eCommerce store, you will need to create a master warehouse in Sage 200 and aggregate the stock there before sending it to Sage 50 Shopify.
All your orders will be saved in the Sage 50 Shopify cloud, and as soon as a connection is re-established with Sage 200, your orders will propagate automatically.
Can I add a B2B/Trade store sales channel linked to Sage Sage 200 if I set up my account in “retail” store mode only?
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 200 Evolution to enable B2B functionality.
How does Sage 50 Shopify pricing work for Sage 200 Evolution and your eCommerce integration?
You pay per connector for your store, so you need to select a data source (in this case, Sage 200) and then a sales channel (e.g WooCommerce). Each connector falls into 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 WooCommerce 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.
If you change your ERP/Accounting system, you will need to register a new Sage 50 Shopify account and configure it with the new ERP details. It’s easy to export all your merchandising data from one Sage 50 Shopify account to another via CSV as all the merchandising information will be preserved.
The Sage 50 Shopify 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. Please note, your billing commences once your data has been synced through from your accounting software, and is not based on your website being “live” or “transactional”.