Step 1 – Set Connectivity of WooCommerce and SAP Business One

Step 1 – Set Connectivity of WooCommerce and SAP Business One


  1. Choose the SAP Business One SLD to provide the connection between SAP Business One System Id and WooCommerce Id.

Note

By default, the solution displays all the SAP Business One SLDs available in SLD Category selected during customer creation.

 

  1. To add a new SLD or edit existing SAP Business One SLD under SAP Business System Id area, choose Add / Edit button. 


The SAP Business One Connection Details window contains the following fields:

Field Name

Description

SLD Category

Displays the SLD Category selected during customer creation. This field is read only.


System Name



Enter the name of the system.

Note

System Name is the mandatory field to add or update SAP Business One SLD.

SAP Business One Server



Enter SAP Business One Server Name / IP Address.

Note

SAP Business One Server  is the mandatory field to add/update SLD information for SAP Business One.

License Server


Enter License Server details. i.e. Server Name or IP Address and port number of the SAP Business One License Server.

The default port is 30000. 

SLD Server



Enter the valid SLD Server details with port.

Note

SLD Server details is the mandatory field to add/update SLD information for SAP Business One.

Database Name





Enter the name of the SAP Business One Database.


Database Name is the mandatory field to add/update SAP Business One System SLD.

Caution

The Database Name must be entered same as SAP Business One Database Name.

Database Type



Currently, only Microsoft SQL Server 2005, 2008, 2012, 2014, 2016, 2017 and SAP Hana DB are supported. Choose the database type from the dropdown list.

Note

Database Type is the mandatory field to add/update SAP Business One SLD.

Database User



Enter the user to access the company database using the database connection. Database User is the mandatory field to add/update SAP Business One SLD.

Caution

The Database User must be valid. Invalid Database User will result in failure to establish the connection.

Database Password



Enter a valid password for database login. 

Note

Database Password is the mandatory field to add/update SAP Business One SLD.

Caution

The Database Password must be valid. Invalid Database Password will result in failure to establish the connection.

Database Port

Enter the port for database.

Username


Enter B1i in this field.

Note

Username is the mandatory field to add/update SAP Business One SLD. It is set as B1i by default and un editable.

Caution

Ensure that a user with this name exists in the SAP Business One database. 

Password

Enter a valid password for B1i user of SAP Business One.

Language

Select the language from the list of languages.

Is Trust


Select True or False. The default value for this field is False. To use a trusted connection, choose True from the dropdown list.

JcoPath

Enter path for jco library. Example of Installation path of JCO: C:\Program Files (x86)\SAP\SAP Business One DI API\JCO\LIB

DI ProxyHost




The DI Proxy host must be defined if B1i is installed on a separate server (this is, other than the SAP Business One server). 

The value in this field must be same as SAP Business One Server address.

Example

Proxyhost can be same as SAP Business One Server. 

DI ProxyPort

The default value of DI Proxy Port is 2099. 

Proxy Host


The proxy host is defined in a multi-instance scenario. If the B1i server connects to the SAP Business One server through a proxy server then, enter the address of the proxy server in this field.

Proxy Port

Enter the proxy port in this field.



  1. Enter the valid data and choose the Submit button. An SAP Business One SLD is created.
  2. Choose the Test Connection  icon to test the connection between the SAP Business One System Id in Integration Hub and SAP Business One System Landscape Directory.

If the connection is successful, a success message appears “Test Connection Successful”. If the connection is unsuccessful, a failure message appears “Test Connection Failed”. Please provide the correct credentials. 


  1. To add / edit WooCommerce instance SLD under WooCommerce Id area, choose the  Add / Edit button. 

 

      The WooCommerce Connection Details window contains the following fields:

Field Name

Description

SLD Category

Displays the SLD Category selected during customer creation. This field is read only.


System Name



Enter the name of the system.


System Name is the mandatory field to add or update WoCommerce SLD.

Protocol

Select Protocol from HTTP / HTTPS.

Host Name

Hostname of WooCommerce site. The hostname is fully qualified domain name. For Example if you access WooCommerce site using URL: https://myhubstore.wpcomstaging.com/wp-admin/ , then the hostname of the WooCommerce site is : myhubstore.wpcomstaging.com


Consumer Key

Enter the Consumer Key generated by WooCommerce. 
  Note

To create keys for a specific WordPress user:

1.Go to: WooCommerce > Settings > Advanced > REST API. Select Add Key. You are taken to the Key Details screen.

2.Add a Description.

3.Select the User you would like to generate a key for in the dropdown.

4.Select a level of access for this API key — Read/Write access.

5.Select Generate API Key, and WooCommerce creates API keys for that user.

6. you should see Consumer Key and Consumer Secret keys

Consumer Secret

Enter the Consumer Secret Key generated by WooCommerce.



  1. Provide the valid information in the fields and choose the Submit button. SLD for WooCommerce will be created.

  

  1. Choose the Test Connection  icon to test the connection between the Integration Hub and WooCommerce.

If the connection is successful, a success message appears “Test Connection Successful”.

If the connection is unsuccessful, a failure message appears “Test Connection Failed”.


  1. Choose the Next button to proceed to Step2.

 


Next step: Step 2-  Scenario Selection of WooCommerce in the Integration Hub

    • Related Articles

    • Step 2 – Scenario Selection of WooCommerce in the Integration Hub

      The Scenario Selection summary displays the Scenario Name, Data Direction, and Field Mapping. The Field Mapping further displays information of Field in SAP Business One and mapped field in WooCommerce.       Configuration Summary 2.   The ...
    • Initialization Process of WooCommerce in Integration Hub

      Once the WooCommerce feature is enabled in SAP Business One, it is mandatory to initialize the objects to be integrated between SAP Business One and WooCommerce. The objects include Products, Inventory, Customer. Note Ensure that the Weight Unit and ...
    • WooCommerce integration with SAP Business One

      WooCommerce is an open-source e-commerce plugin for WordPress. It is designed for small to large-sized online merchants using WordPress. The integration between WooCommerce and SAP Business One facilitates automated, bi-directional data exchange ...
    • General Settings of WooCommerce in the Integration Hub

      Configure the general settings in the General Settings tab in WooCommerce Settings window. The General Settings tab of WooCommerce Settings window contains the following fields: Field Name Description Default Price List used for Items Prices ...
    • Step 3 - Deployment of WooComerce in SAP Business One Integration Hub

      To deploy the solution, choose the Deploy Now button. The application prompts you to provide the license details. For more information, refer to the Assigning the Integration Hub licenses Knowledge Article. The Integration Hub displays the Deployment ...