Sage 50 Accounts UK

Sage 50 Accounts UK is an on-premise accounting system. Stock2Shop will therefore be pushing updates from your Sage database using our Apifact software

Sage 50 Accounts UK is client-owned. This means that the ERP application is installed on a server at your office, on an on-site computer or on a server in the cloud. In order for Stock2Shop to facilitate integration between Sage 50 Accounts UK and other sales channels and fulfilment services (e.g. Shopify, Magento 1.x, Magento 2.x, WooCommerce, the B2B Trade store, Parcelninja and Takealot Marketplace), we need access to the Sage 50 Accounts UK database.

In the below documentation we will be covering:

Connecting to Stock2Shop

In order for Stock2Shop to connect with Sage 50 Accounts UK, Stock2Shop requires the following:

  • Stock2Shop’s Apifact software installed on the ERP server
  • Database name
  • Database path (C:\ProgramData\Sage\Accounts\2023\DemoData\ACCDATA)
  • Version of Sage50 Accounts UK (eg: V29)
  • Read / Write Sage 50 UK user name and password (dedicated for Stock2shop)
  • SDK
  • ODBC driver

For more information on the installation of Stock2Shop’s Apifact software, see our guide on installing Stock2Shop for on-premise ERP / accounting systems.

Syncing products to Stock2Shop

Stock2Shop can sync products, product relationships (parent-child), categorisation, quantity and multiple price lists (tiers) from Sage 50 Accounts UK to your Stock2Shop console. This product information can then be distributed to one or multiple supported B2B and or B2C ecommerce sales channels.

To understand more about the concept of products in Stock2Shop, read here.

Syncing customers to Stock2Shop

Stock2Shop can sync customers' details, account information, and customer-specific pricing from Sage 50 Accounts UK. This customer information can then be distributed to our B2B Trade Store, allowing your customers to view products and place orders.

To understand more about the concept of customers in Stock2Shop, read here.

Raising orders to Sage 50 Accounts UK

Stock2Shop can sync quotes, sales orders and invoices to Sage 50 Accounts UK, using the order payload received from your sales channel(s). Note that the SDK and ODBC driver comes preinstalled with Sage 50 UK.

To understand more about the concept of orders in Stock2Shop, read here.