Configuring the Integration between Sage Business Cloud and Shopify, enriching product data has never been easier.
Automate price & stock
Stock, price and product data sync from Sage Business Cloud to Shopify.
Orders raise in Sage Business Cloud
Orders placed online will raise automatically in Sage Business Cloud from Shopify, no data capturing required.
Diagram of Shopify Workflow Layout
Once your API connection is set up with Sage 50 Shopify and Sage Business Cloud sync, the following information will be available to send to any one of your sales channels (WooCommerce, Shopify etc.).
- 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 Business Cloud to Sage 50 Shopify is the first step towards integrating with your eCommerce site/Marketplace.
Once this data is in Sage 50 Shopify, you can enrich your products with merchandising (images, gallery images, categories, filter tags, product variables/sizes/colours and more), activate/delete products and flag products to sync to your sales channels (WooCommerce, Shopify etc).
Connecting Sage 50 Shopify to your sales channels 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 WooCommerce/Shopify, so product merchandising, pricing & stock will update automatically.
If you have an existing eCommerce store, and would like to sync it with your Sage Business Cloud 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 (eCommerce stores or Marketplaces).
Merchandising on channel - This mode is used when you have an existing eCommerce 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 eCommerce store into Sage 50 Shopify.
Upon an order being placed on your sales channel, Sage 50 Shopify is notified and the order is raised consequently in Sage Business Cloud. You can determine what order type/document type is raised in Sage Business Cloud (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).
The order information raised in Sage Business Cloud 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 Business Cloud may contain a prefix that you define, like “SHO”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 Business Cloud to Sage 50 Shopify under one profile, but you may register a new account with Sage 50 Shopify 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.
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 Business Cloud to enable B2B functionality.
You pay per connector for your store, so you need to select a data source (in this case, Sage Business Cloud) and then a sales channel (Shopify).
So it would be:
- R750 ex VAT for Sage Business Cloud data connector 0-500 SKUs
- R630 ex VAT for Shopify sales channel connector 0-500 SKUs
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 Storehub.io 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 remain 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. Note, that billing does NOT commence only when your website is live, as that is not the function of, or in the domain of Sage 50 Shopify.