Tools

Sana Commerce 9.2
Your connector

ERP Connection



Sana Commerce allows to accept orders when there is no connection to your ERP system. When there is no connection between Sana and ERP, Sana enables the maintenance mode. 

The Sana Commerce framework can be connected to one ERP system as well as to different ERP systems simultaneously to get data from various sources.

To configure ERP connection in Sana Admin click: Tools > ERP connection.

Maintenance mode

The table below provides the description of the settings that allow to accept orders from the Sana Commerce webstore when there is no connection to ERP:

Settings Description
Maintenance mode Use this option to enable/disable the maintenance mode manually.
Number of connection failures before auto switching to maintenance mode Select the number of connection failures before the webstore automatically switches to the maintenance mode.

If there are some problems with connection to your ERP system, this number indicates how many connection failures should take place one after another before the webstore automatically switches to the maintenance mode.

ERP connection status Here you can see the connection status to your ERP system.

If connection is not available, there is a button Try to reconnect. When connection is restored, click Try to reconnect to switch to online.

You can also click Test connection in the Default connection/Custom connections area(s) to check your connection to ERP.

There is also the ERP connection status check task that can be set up to automatically check connection availability and when it is available this task switches the webstore to the online mode automatically.
For more information, see 'Scheduled Tasks'.

The webstore can switch to the maintenance mode only if data is synchronized with the ERP system. To synchronize data with your ERP system to allow a Sana webstore to work in the maintenance mode, you should run the General information import task. For more information, see 'General information import'.

To show catalog prices in the maintenance mode, in Sana Admin click: Setup > Products > Price, and enable the option Price visibility when ERP connection is not available. When you enable this option, you need to reindex the catalog by running the Product import task. For more information, see 'Product Import'.

Sales orders that are placed in the maintenance mode can be viewed and processed in Sana Admin: Sales > Unprocessed orders. For more information about sales orders placed in the maintenance mode, see 'Unprocessed orders'.

System administrator receives an e-mail, when the maintenance mode is activated/deactivated. It is sent to the recipient e-mail address specified in the store information settings in Sana Admin: Setup > Basics > Store information. The text of the e-mail can be managed in the e-mail templates. To notify system administrator when the maintenance mode is activated/deactivated two e-mail templates are used:

  • [SHOPNAME] ERP connection not available. Maintenance mode activated.
  • [SHOPNAME] ERP connection available. Maintenace mode deactivated.

For more information, see 'E-mails'.

There are three states of the maintenance mode:

Maintenance mode Description
Full This is the default state of the maintenance mode. When there is no connection between Sana and ERP, and all required data is synchronized, a Sana webstore continues to work, and customers can create orders.
ViewOnly When there is no connection between Sana and ERP, and all required data is synchronized, a Sana webstore continues to work, but with limited functionality. Customers can still browse the catalog, but they cannot order.
Disabled When there is no connection between Sana and ERP, a Sana webstore does not work. Users will see a page with a message that a webstore is temporarily unavailable.

You can change the state of the maintenance mode in the 'Web.config' file of the Sana Commerce frontend.

<add key="OfflineModeSupport" value="Full" />

Connections

In the Default connection/Custom connections areas you can set up connection(s) to the ERP system.

You can set up connection to one ERP system as well as to different ERP systems simultaneously to get data from various sources.

Sana Commerce framework consists of the following subsystems:

  • Catalog
  • Customer
  • Common
  • Order
  • Price
  • Stock

All data can be stored and retrieved from one ERP system or you can connect each subsystem to different ERP systems. For example, it is possible to get product master data from some product information management system like Perfion, prices from one ERP system and inventory from another ERP system.

 NOTE

If you are going to connect Sana subsystems to different ERP systems, then products, customers, etc. should be available in all these systems with the same identifiers to synchronize data. For example, when a customer places an order in system A and product information is retrieved from system B, then a product with the same ID should be present in both systems.

If you connect your webstore to one ERP system you can set up connection only in the Default connection area. If you connect some subsystems of the Sana Commerce framework to different ERP systems or to one ERP system but via multiple web services, set up the appropriate connections in the Custom connections area.

The table below provides the description of the fields to set up ERP connection:

Field Description 
Provider Type of provider.

Sana Commerce delivers only one global provider type - eBusiness, which can be connected to any ERP system.

By default Sana Commerce is integrated with Microsoft Dynamics NAV, Microsoft Dynamics AX and SAP.

Connection type Select your connection type. The connection type determines which ERP system you are connecting to.
Webservice URL Enter the webservice URL of your ERP system.

If you do not have the webservice URL, contact the person who is responsible for setting up your ERP environment(s).

See examples:
Microsoft Dynamics NAV
http://domain.com:7047/DynamicsNAV/WS/CompanyName/Codeunit/SC_NAV_WebService

Microsoft Dynamics AX
http://domain.com/AX2012WebService/AXService.svc

User domain Enter the domain and credentials of the user who is accessing the ERP system.

If you do not have the domain and credentials of the user who is accessing the ERP system, contact the person who is responsible for setting up your ERP environment.

User
Password
Connection timeout Determines the time to wait while trying to establish a connection before terminating the attempt. You can set the amount of time in seconds a connection waits to time out. A connection timeout means that a server is taking too long to reply to a data request.
Default: 60 seconds
Enable logging If logging is enabled all requests from the Sana Admin and webstore to ERP and responses will be written into the tracelog file on the server.
By default logging is disabled as it affects performance. Therefore, it is better to use it only for debugging purposes.
For more information about logging in Sana Commerce, see 'Sana Commerce Logging'.
Extra parameters This field is used when you need to specify some extra parameters in the connection to ERP. Use the ';' character to separate multiple parameters.

When connection to your ERP system is configured, click Test connection to check whether the connection is available.