Summary
This mapping enables the synchronization of Shopify product collections/categories into iPaaS. It ensures that category hierarchies and naming conventions from Shopify are properly reflected in iPaaS, supporting catalog organization and product classification.
This mapping only supports category additions, as Shopify categories are typically managed as collections. Updates are also possible where category identifiers remain consistent.
Field Constraints
Name must be unique within iPaaS.
ParentId must reference an existing category in iPaaS to maintain hierarchy.
Mapping Collection Status
Status: Enabled
Trigger Events: Product Category Add or Update in Shopify.
Id Format
When manually transferring data from Shopify to iPaaS, it is essential to enter the correct Product Category Id (e.g., 10) into the iPaaS input field on the manual sync page.
Duplication or Conflicting Collections
This is the only active mapping collection for Product Category sync. No other overlapping Product Category-to-Product Category collections exist
System Caveats
Shopify Caveats
Shopify “Collections” may not have a strict parent-child hierarchy; additional logic may be required for ParentId assignment.
iPaaS Caveats
If ParentId is not provided, categories will be created at the root level in iPaaS.
Setup Requirements
iPaaS Configuration
Enable Shopify Product Category Add/Update To iPaaS mapping collection.
Ensure ParentIds are correctly defined through dynamic formulas or manual mapping.
Shopify Configuration
In the integration settings, enter the following correctly.
OAuth URL Template:
https://{API Store}.myshopify.com/admin/oauth/authorize?client_id={SystemTypeVersion:Client_Id}&scope={SystemTypeVersion:Scope}&redirect_uri={SystemTypeVersion:RedirectUrl}&state={iPaaSState}
OAuth Identifier Field: timestamp
OAuth Success Callback Field: code
Shopify Store Credentials
Client_Secret: Secret saved when creating your Shopify store
Scope: read_Product, read _Product_feeds, read _Product_listings, read_inventory, read_files
RedirectUrl:
https://portal.ipaas.com/Product Category/subscription-mgmt/subscriptions/authorization/app
Authentication & Security
OAuth 2.0 Token: Used for Shopify API authentication.
Integration Flow
Category data is fetched from Shopify (Title, Handle).
Categories are created in iPaaS with the mapped Name and Description.
Dynamic Formula assigns ParentId if a parent category is defined.
Categories without ParentId are added at the root level in iPaaS.
Mappings
Shopify Product Category to iPaaS
Mapping Type | Source Field (Shopify) | Destination Field (iPaaS) | Description |
Field | Title | Name | Required |
Field | Handle | Description | Recommended |
Dynamic Formula |
| ParentId | Since Shopify does not have a category hierarchy in the REST API, this mapping will preserve the existing category hierarchy defined in iPaaS. |
Error Handling
Duplicate Category Name: iPaaS may reject duplicate names.
Invalid ParentId: Category may fail to insert if ParentId does not exist in iPaaS.
Testing & Validation
Test Scenarios
Root Category Creation: Category created without ParentId.
Sub-Category Creation: Category created with a valid ParentId.
Duplicate Name Handling: Validation for unique category names in iPaaS.
Validation Rules
Name is required.
ParentId must be valid (if provided).
Validation Checklist
Category appears in iPaaS with the correct name and description.
Parent-child hierarchy is applied correctly.
Duplicate categories are not created.
Additional Notes
Categories must be validated in iPaaS to prevent duplication.