Sage 50cloud Pastel Xpress

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

Sage 50cloud Pastel Xpress is client-owned. This means that the Sage 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 50cloud Pastel Xpress 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 database.

In the below documentation we will be covering:

Connecting to Stock2Shop

In order for Stock2Shop to connect with Sage 50cloud Pastel Xpress, Stock2Shop requires the following:

  • Stock2Shop’s Apifact software installed on the Sage server
  • Server name
  • Database name
  • Database path (c:\Pastel18\abc)
  • Version of Sage 50cloud Pastel Xpress (e.g. Pastel 18)
  • DBQ (DDF Builder database name)
  • Database username (read-Only)
  • Database password (read-Only)
  • Paster Partner SDK

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, multiple warehouses and multiple price lists (tiers) from Sage 50cloud Pastel Xpress 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

We currently do not support the syncing of customers from Sage 50cloud Pastel Xpress to Stock2Shop, and there are no plans to build this functionality.

If customers are a requirement, please read up on how to import customers manually in to your client console here.

Raising orders to Sage 50cloud Pastel Xpress

Stock2Shop can sync quotes, sales orders and invoices to Sage 50cloud Pastel Xpress, using the order payload received from your sales channel(s). To enable us to do this, you will need to install the Pastel Partner SDK (software developers’ kit) client connector. Please contact Sage directly to get this business object in place, or ask your Sage consultant to assist. The SDK client connector has an annual fee which is paid directly to Sage.

The process for getting your SDK installed is as follows:

  • Phone the Sage 50cloud Pastel Xpress sales department and request the “Pastel Partner SDK client connector”.
  • They will send you an indemnity form to fill out and send back to them.
  • They will then send you a registration code.
  • Phone the Sage 50cloud Pastel Xpress registrations department and ask them to “register” the SDK connector.

Once this is done you should see the module reflect in your Sage 50cloud Pastel Xpress by viewing “Help > About” in the Sage main menu.

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