Add/Update OroCommerce Customer Group From iPaaS.com

NOTE: For Customer Category Collection, the custom field module must be CustomerGroup.

NOTE: This Field Name will also be used when you create an iPaaS.com custom field, below.

Storage Type

Schema Update required?

Notes

Table Column

Yes (Mandatory)

After creating a custom field, click the red Update Schema button to apply the changes. The custom field is not available until the schema update completes.

Caution: Contact your OroCommerce administrator before changing an entity schema to prevent unexpected service downtime.

Serialized Field

No (automatic)

Recommended. The custom field is automatically added to the schema.

Mapping Type

Source Field (iPaaS)

Destination Field (OroCommerce)

Description

Dynamic Formula

var value = GetCustomFieldValue(CustomFields, "CustomField11"); if (string.IsNullOrEmpty(value)){return null;} else {return value;}

CustomField11

Retrieves the value of the custom field “CustomField11” from the available custom fields. If the value is empty or null, it returns null; otherwise, it returns the retrieved value.

Static

customergroups

Type

Sets the OroCommerce Type to the static value customergroups. This is a required field. This value is case-sensitive. This field is required to create a customer category. The type must be "customergroups". NOTE: This value is case-sensitive

Field

Name

Attributes_Name

Maps the iPaaS Name to the OroCommerce Attributes_Name. This is a required field.

Dynamic Formula

var id = await GetOrganizationIdByNameAsync("iPaaS.com"); return id;

LastName Relationship_Org_Id

Retrieves the OroCommerce organization ID by looking up the organization name. This ID links the customer group to the correct business unit. This dynamic formula accepts an organization name as a string input and returns the corresponding organization ID, which is used for creating and updating the customer category.

Static

organizations

Relationships_Org_Type

Sets the OroCommerce Relationships_Org_Type to the static value organizations. This is a required field. This is a required field that contains the static relationship organization type "organizations", which is used to map the organization to the customer category during creation and update of the customer category.

Dynamic Formula

var id = await GetUserIdByUsernameAsync("admin"); return id;

Relationship_Owner_Id

Retrieves the OroCommerce user ID by looking up the username. This ID assigns ownership of the customer group. This dynamic formula expects a string user name as input and returns the user Id.

Static

users

Relationship_Owner_Type

Sets the OroCommerce Relationship_Owner_Type to the static value users. This is a required field. This is a required field that contains a static relationship owner/user type "users", which is required to map the user to the customer category.

Dynamic Formula

var id = await GetPaymentTermIdByPaymentTermAsync ("net"); return id;

Relationship_PaymentTerm_Id

Sets the OroCommerce Relationship_Owner_Type to the static value users. This is a required field. This dynamic formula expects a string payment name as an input and returns the payment Id that will be used in creating and updating the customer group.

Static

paymentterms

Relationship_PaymentTerm_Type

Sets the OroCommerce Relationship_PaymentTerm_Type to the static value paymentterms. This is required to map payment terms to customer groups. The CreatedAt field is mapped to the custom field CreatedAt in iPaaS when the data is created in Square Up.

Dynamic Formula

var id = await GetCustomerTaxCodeIdByTaxCodeAsync ("STATE_GOVERNMENT"); return id;

Relationship_TaxCode_Id

Retrieves the OroCommerce tax code ID by looking up the tax code name. This ID associates tax codes with the customer group for taxation logic.

Static

customertaxcodes

Relationship_TaxCode_Type

Sets the OroCommerce Relationship_TaxCode_Type to the static value customertaxcodes. This is required to map tax codes to customer groups. This is the required field that contains a static relationship tax code type "customertaxcodes", which is required to map tax code to customer category while creating and updating customer category.