UDF Integration for Shopify Connector in Integration Hub

UDF Integration for Shopify Connector in Integration Hub

The Shopify connector supports the integration of User Defined Fields (UDFs) between the Shopify and SAP Business One applications. This functionality allows users to map the existing User Defined Fields (UDFs) in Shopify and SAP Business One. This is particularly useful when the UDFs with the same length, datatype, and structure exist in both applications and can be mapped for seamless integration. By leveraging this feature, businesses can ensure that custom data fields are synchronized between Shopify and SAP Business One.

The Shopify connector supports the integration of User Defined Fields (UDFs) on the following Objects:

1.        Customer

2.       Products

3.       Variants

4.       Sales Order

To perform the UDF Integration, follow these steps:

1.                Open the UDF Integration window by navigating to Administration → Integration Hub → UDF Integration.

2.               The UDF Integration-Selection Criteria window will appear.

3.               The active template for the Shopify connector will automatically be displayed in the Template Name field.

4.               Select the specific object you want to map UDFs for in the Object Type field.

5.               Click OK to open the UDF Integration Mapping screen.

6.              Click the Retrieve Custom Fields button to fetch the list of Shopify custom fields.

7.               In the left column titled SAP User Defined Fields (UDF), select the SAP UDFs. In the Mapped to Shopify Custom Fields column, select the corresponding Shopify custom fields.

8.               In the Data Type column, choose the data type for the Shopify custom fields.

9.              Click the Add/Update button to save the data. 

         The following Shopify data types for custom fields are supported for the UDF integration with SAP Business One:

Shopify Data Type

SAP B1 UDF Type

Single line Text

Alphanumeric

Integer

Numeric

Single line Text

Rate, Amount, Price, Quantity, Percents, Measure

boolean

Checkbox

 

Note

1. If there is no data in the Shopify custom fields for a master record or transaction, the corresponding custom field information will not be included in the Shopify payload. As a result, it will be ignored during UDF integration. This occurs because the Shopify API does not retrieve data for empty custom fields.

To ensure successful data integration, consider the following approaches:

·        Integration from SAP Business One to Shopify: Enter default or dummy data into the Shopify custom field to ensure it is retrieved in the Shopify payload and overwritten with information synced from SAP.

·         Integration from Shopify to SAP Business One: Ensure that the correct information is entered into the custom fields in Shopify before initiating the sync.

2. The user needs to ensure that they have mapped the correct UDFs with the same data type, length, and structure between the applications.

3. Later on, if you do not want to integrate UDF information between the applications, you may delete the relevant row from the UDF Integration Mapping screen. Once the row is deleted, the UDF information will no longer be integrated during the initialization and synchronization process.

  Caution

The SAP Business One UDFs with "Linked to Entities" Validation will not appear in the column SAP User Defined Fields (UDF).

 

    • Related Articles

    • Shopify integration with SAP Business One

      Shopify is an e-commerce platform that allows users to create online retail stores. This cloud-based platform gives the flexibility to access and run a business from anywhere. Shopify allows users to: Create and customize an online store. Sell in ...

    • Step 3 – Deployment of Shopify in the Integration Hub

      The Integration Hub pre-checks the configurations before the solution can be deployed. The Configuration Summary table is displayed. If all steps are successful, the solution is ready for deployment. To deploy the solution, choose the Deploy Now ...

    • Step 1 – Set Connectivity of Shopify in the Integration Hub

      1.Choose the SAP Business One SLD to provide the connection between SAP Business One system ID and the Shopify ID. Note By default, the solution displays all the SAP Business One SLDs available in the SLD Category field selected during customer ...

    • Alerts Notification of Shopify in the Integration Hub

      Configure the alert settings on the Alerts Notification tab in the Shopify window in SAP Business One. The Alerts Notification tab in the Shopify window contains the following fields: Field Name Description User Displays the list of users in SAP ...

    • Shopify Transactions in the Integration Hub

      The following Shopify transactions are supported: Sales Order Payment Order Cancellation Fulfillment Refund Windows Enhancements in SAP Business One New fields that are relevant to the Integration Hub have been added to different document windows in ...