SYSPRO

SYSPRO is an on-premise ERP system. Stock2Shop will therefore be pushing updates from your ERP database using our Apifact software.

SYSPRO 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 SYSPRO and other sales channels and fulfillment services (e.g. Shopify, Magento 1.x, Magento 2.x, WooCommerce, the B2B Trade store, Parcelninja and Takealot Marketplace), we need access to the SYSPRO database.

In the below documentation we will be covering:

Connecting to Stock2Shop

In order for Stock2Shop to connect with SYSPRO, Stock2Shop requires the following:

  • Stock2Shop’s Apifact software installed on the ERP server
  • Server name / IP address
  • Database name
  • Database username (read-only)
  • Database password (read-only)
  • Operator login
  • Operator password
  • Company ID
  • Public SYSPRO eNet Web Services URL
  • SYSPRO version

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 SYSPRO 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, customer-specific pricing and customer-specific quantity from SYSPRO. 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 SYSPRO

Stock2Shop can sync quotes, sales orders and invoices to SYSPRO, using the order payload received from your sales channel(s). To enable us to do this, you will need to install the SYSPRO eNet Web Services and, at a minimum, the “SORTOI” business object to be enabled. The web service should be accessible via a public URL or IP address, e.g.: http://123.123.123.123/sysprowebservices/utilities.asmx

In addition, we would also require the following details:

  • Operator Login
  • Operator Password
  • Company ID

Please ask your ERP consultant to assist you in getting this business object configured correctly.