Sage 50 Partner WooCommerce
Integration

Automate Stock, Price & Order Updates from WooCommerce to Sage 50. Sage 50 B2B Commerce Available Too.

Woocommerce Integration With Your Accounting Software - Storehub.io
Storehub.io - Sage Integrated eCommerce Solutions

Sync Sage 50 Partner and WooCommerce in Minutes

Configuring Sage 50 Partner to sync with your WooCommerce store can be done in minutes, no expensive setup fees or complex code required.

Start syncing price, stock & orders same-day with our same-day turnaround promise.

Stock & Price Sync from Sage 50 Partner to WooCommerce, save time

Stock, price and product data sync from Sage 50 to WooCommerce 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 Partner to WooCommerce could be spent growing your business.

Storehub.io - Sage Integrated eCommerce Solutions
Storehub.io - Sage Integrated eCommerce Solutions

Orders raise in Sage 50 Partner from WooCommerce

Orders placed online will raise automatically in Sage 50 from WooCommerce, no manually keying in data or errors. Capturing orders manually raises the risk of errors significantly. Introduce 100% accuracy with Storehub.io with auto capturing of delivery address, contact details, shipping costs, product items and delivery notes.

Why Integrate Sage 50 Partner and WooCommerce?

When selling online, a lot of data moves between your accounting software and WooCommerce store. An integration with Sage 50 Partner and WooCommerce 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 Partner and WooCommerce, orders placed online also integrate back from WooCommerce into Sage 50, meaning there’s no repetitive manual data capturing work or the errors associated with keying in large volumes of data.

Once your SDK connection is set up with Storehub.io and Sage 50 Partner syncs, the following information will be available to send to Storehub.io and thereon to WooCommerce 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 your sales channels (WooCommerce, Shopify etc).

Connecting Storehub.io to your WooCommerce store 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 WooCommerce 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 one eCommerce store or a Marketplace like Amazon or eBay).

Merchandising on WooCommerce – This mode is used when you have an existing WooCommerce 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 WooCommerce, Storehub.io is notified and the order is raised consequently in Sage 50 Partner. You can determine what order type/document type is raised in Sage 50 Partner (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 Partner 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 50 Partner may contain a prefix that you define, like “WOO”0018443 – this helps identify the order at a glance.
Sage Evolution 200 B2B eCommerce Integration - Storehub.io

Other FAQs Relating to Sage 50 Partner Integration with WooCommerce

Yes, you may have as many WooCommerce channels as you like. Each WooCommerce channel will accrue an additional connector cost.

You can not link multiple instances of Sage 50 Partner to Storehub.io and WooCommerce under one profile, but you may register a new account with Storehub.io and link it.

All your orders will be saved in the Storehub.io cloud, and as soon as a connection is re-established with Sage 50 Partner, your orders will populate automatically.

You may only send one warehouse data set to your WooCommerce store. If you need to aggregate the stock from multiple warehouses and display it on one WooCommerce store, you will need to create a master warehouse in Sage 50 Partner and aggregate the stock there before sending it to Storehub.io

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 Partner to enable B2B functionality.

You pay per connector for your store, so you need to select a data source (in this case, Sage 50 Partner) and then one or more WooCommerce sales channels. 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 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.

Sage 50 WooCommerce Integration FAQs

In order to integrate Sage 50 Accounting with your WooCommerce store you need to choose the right software to get it done easily.

Using Storehub.io, you can easily integrate Sage 50 with your WooCommerce store by simply installing the sync tool on your Sage 50 server – this will push data to Storehub.io and also allow data to be written back to Sage 50 Accounting.

With your Sage Business Cloud integration to Storehub.io, price, stock and inventory tax types all push to your WooCommerce store without any manual intervention.

In order to integrate stock, price and orders between Sage 50 Accounting and WooCommerce, we’ll need to connect Sage 50 to Storehub.io.

Click the “Add Data Source” button on your brand new Storehub.io account, and copy your unique sync code and enter that in on your installed sync app on the Sage 50 server. 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 50 Accounting with your WooCommerce store, all you need to do is install the sync tool on your Sage 50 Accounting server.

All information required to automatically sync orders from your WooCommerce store is done so automatically, with:

  • 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 Storehub.io WooCommerce store.

 

In order to integrate Sage 50 with your WooCommerce , you’ll need to ensure the following is in place.

  • Cash sales customer: This is flagged as a “cash sales” customer type. It wont be used for B2B store but is still required.
  • Delivery service item: All cost of delivery will be allocated to this service item in your accounting software on orders/sales documents generated.
All product SKU codes to be integrated from Shopify or Sage 50 need to exist on both platforms identically otherwise sync jobs with errant SKUs may fail.

In order to pay for the integration cost between Sage 50 Accounting and your WooCommerce store, you need to know how many product SKU codes you wish to sync to/from your WooCommerce store and Sage 50.

  • Pick the “Sage 50 Partner” option here on the pricing page 
  • Pick the “WooCommerce” sales channel, with the appropriate number of SKUs as well on the pricing page
The total cost per month is the total amount for those two connectors.
 

If you’re running a retail eCommerce store like WooCommerce or Shopify, 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 50 from WooCommerce/Shopify AND your B2B Commerce store automatically.

The key difference is the 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 in Sage.

 

In order to sync with Sage 50 and WooCommerce, your Sage 50 accounting software will need to be on V18 or newer in South Africa. This is to ensure you’re using the latest sync tools and database structure in order for the Sage 50 WooCommerce sync integration to be reliable.