3 Install and Configure the Recipe
On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.
Configure the Oracle FTP Connection
Use the following steps to configure the Oracle Connection_ERP_jsonL_Shopify Connection.
Configure the Lookup Tables
- In the Lookups section, click the lookup name.
- Enter the field names and corresponding values. Refer to the details provided for each table below.
- Click Save. If prompted, click Save again.
- To return to the project workspace, click Go back .
The recipe contains the following three lookup tables. Edit them as necessary.
- ORACLE-BRT-PDH_SHOPIFY_CONSTANTS: Used to map
WeightUnit
of items in Shopify with the correspondingWeightUnit
of items in Oracle ERP Cloud.Weight Unit in Oracle ERP Cloud Weight Unit in Shopify kg KILOGRAMS - ORACLE-BRT-ERP_Shopify_PdSync_Notification_Const: Used to configure the email address to which the error notifications are sent when the recipe fails.
Email_Property Email_Value fromAddress Specify the email address from which the notification emails are sent. Enter an email address of your choice. toAddress Specify the email address to which the notification emails are sent. Enter an email address of your choice. - ORACLE-BRT-PDH_SHOPIFY_CONSTANTS_VARIANTS: Used to configure item variants based on item category.
Item_Category_Code ItemEffCategory Variant_Options Variant_Option1 Variant_Option2 Variant_Option3 Smartphone ItemEFFBsm_5Fvariants_5FatgPrivateVO ["Language","Color","Voltage"] _Language _Color _Voltage Smartwatch ItemEFFBsw_5Fvariants_5FatgPrivateVO [“Material”,”Color”] _Material _Color