Sage Business Cloud
Integrate Sage Business Cloud with WooCommerce for Auto Price, Stock & Order Updates - FREE Setup in Minutes
Sage Business Cloud WooCommerce Integration Workflow
Set up the Sage Business Cloud WooCommerce integration in Minutes
Configuring the Integration between Sage Business Cloud and WooCommerce has never been easier. Using Storehub.io the start-to-finish integration takes approximately 10 minutes to complete. Watch a 2 minute walkthrough video here:
Sync Stock & Price to Woocommerce from Sage Business Cloud
Stock, price and product data sync from Sage Business Cloud to WooCommerce instantly, and update every time an order is placed. No more selling out of stock items or at the wrong price!
Orders raise in Sage Business Cloud from WooCommerce
Orders placed online will raise automatically in Sage Business Cloud from WooCommerce, no data capturing required. Save many hours and data inaccuracies of manually keying in each order with order integration.
Once your API connection is set up with Storehub.io 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 Storehub.io is the first step towards integrating with your eCommerce site/Marketplace.
Once this data is in Storehub.io, 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 Storehub.io to your sales channels is as simple as copy-pasting the API keys from WooCommerce onto your Storehub.io account. Once completed, Merchandising data will flow from Storehub.io 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 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 (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 Storehub.io.
Upon an order being placed on your sales channel, Storehub.io 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 WooCommerce to Sage Business Cloud may contain a prefix that you define, like “WOO”0018443 – this helps identify the order at a glance.
Sage Business Cloud WooCommerce integration FAQ
In order to integrate Sage Business Cloud with your WooCommerce store you need to choose the right software to get it done easily.
Using Storehub.io, you can easily integrate Sage Business Cloud with your WooCommerce store by simply entering your Sage Business Cloud Accounting username and password.
With your Sage Business Cloud integration to Storehub.io, price, stock and inventory tax types all push to your WooCommerce store along with Customer information, multiple pricelists, customer specific discounts and more.
Sales Reps also pull through from your accounting software automatically, so the only manual component of setting up your WooCommerce wholesale store would be adding product images/categories and filters if required.
In order to integrate stock, price and orders between Sage Business Cloud and WooCommerce, we’ll need to connect Sage Business Cloud to Storehub.io.
Click the “Add Data Source” button on your brand new Storehub.io account, and enter in your Sage Business Cloud login details. 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.
In order to integrate orders with your Sage Business Cloud Accounting with your WooCommerce store, all you need is your Sage Business Cloud Accounting login details.
All information required to automatically sync orders from your WooCommerce Store is done so automatically, with:
- Product SKU
- Tax types
- Delivery & billing address
- Order reference
Everything you need to fulfill your orders in Sage Business Cloud will be sent through from WooCommerce store.
What information needs to be set up in Sage Business Cloud in order to sync to my WooCommerce Store?
In order to integrate Sage Business Cloud with your WooCommerce store, you’ll need to ensure the following is in place.
- Cash sales customer: This is flagged as a “cash sales” customer type. It will be used to raise orders from WooCommerce in Sage Business Cloud
- Delivery service item: All cost of delivery will be allocated to this service item in Sage Business Cloud on orders/sales documents generated from WooCommerce
In order to pay for the integration cost between Sage Business Cloud and your WooCommerce store, you need to know how many product SKU codes you wish to sync to/from your online store.
- Pick the “Sage Business Cloud” option here on the pricing page, and
- Pick the “WooCommerce” sales channel, with the appropriate number of SKUs on the pricing page
If you’re running a retail eCommerce store like WooCommerce, you can easily add Storehub.io B2B Commerce Wholesale via a link on your eCommerce store menu.
This means you can accept orders back to Sage Business Cloud from WooCommerce AND your B2B Commerce store automatically.
The key difference is the retail WooCommerce store orders will go back to your cash sales customer and the B2B Wholesale store will write back orders to each account customer account.
Integrating Sage Business Cloud with your WooCommerce store is made simple by the fact that Sage Business Cloud is an online accounting suite, and will therefor always be on the latest version, so there’s no need to consider the software version or SDK connector etc.