iPaaS.com to Shopify Product Category Assignment Mapping Documentation
This documentation covers writing product-to-category membership from iPaaS.com to Shopify (transfer FROM iPaaS.com). A Product Category Assignment links an iPaaS.com product to a category; in Shopify that means adding a product to a collection. Two mapping collections handle this direction:
Add Shopify Product Category Assignment FROM iPaaS.com adds a product to a Shopify collection.
Delete Shopify Product Category Assignment FROM iPaaS.com removes a product from a Shopify collection.
Both collections resolve the Shopify collection id and Shopify product id from their iPaaS.com links and only run once the category has been linked to a Shopify collection (enforced by a mapping filter). There is no opposite (TO iPaaS.com) assignment collection — product-to-category membership is managed FROM iPaaS.com to Shopify only.
ID Format
Manual Sync ID: the iPaaS.com Product Id concatenated with the Product Category Assignment Id using a pipe character —
<ProductId>|<AssignmentId>(for example,12345|10), entered on the iPaaS.com Manual Sync page.
Deleted Record Support
Deletion is supported. The Delete Shopify Product Category Assignment FROM iPaaS.com collection removes a product from a Shopify collection when the assignment is deleted in iPaaS.com. Removing the assignment does not delete the product or the collection — only the product's membership in that collection is removed.
Mapping Collection Status
Status: Enabled (both collections apply a category-link mapping filter; see below).
Trigger Events: the iPaaS.com Product Category Assignment Create outbound trigger routes to the Add collection; the Delete outbound trigger routes to the Delete collection.
Duplicate or Conflicting Mappings
The Add and Delete collections are complementary, not conflicting — each manages one side of collection membership. There is no TO-iPaaS.com assignment collection, so there is no opposite-direction overwrite risk for this entity.
Supported Child Collections
None. Both collections are standalone with no dependent child collections.
System Caveats
Shopify Caveats
Both records must exist in Shopify. The product and the collection must both be present in Shopify for an assignment to add or remove; Shopify returns a not-found error otherwise.
Write access required. The Shopify connection must be authorized to write products/collections to manage collection membership.
iPaaS.com Caveats
Category must be linked. The mapping filter processes an assignment only when the assignment's category already has a Shopify collection external id. Assignments for unlinked categories are skipped. This is the safety net behind the category prerequisite — categories are linked to Shopify automatically (see Integration Flow), so subscribers do not need to pre-sync categories by hand.
Product must be linked. The ProductId formula resolves the Shopify product id from the product's link. If the product is not yet synced to Shopify, no id resolves and the assignment cannot complete.
Setup Requirements
iPaaS.com Configuration
Enable the Add Shopify Product Category Assignment FROM iPaaS.com and Delete Shopify Product Category Assignment FROM iPaaS.com mapping collections, and subscribe to the iPaaS.com Product Category Assignment Create and Delete outbound triggers in the subscription configuration's Outbound Data Flows section. No automatic transfers occur until those subscriptions are enabled. Assignments can also be sent on demand from the Manual Sync page using the pipe-joined Product Id and Assignment Id.
To make assignments succeed automatically, also configure the Product Category collections (so categories link to Shopify) and the Product collections (so products link to Shopify).
Shopify Configuration
The Shopify connection must be authorized with write access to products and collections.
Integration Flow
An iPaaS.com Product Category Assignment Create or Delete is dispatched for a product/category pair.
The mapping filter checks whether the assignment's category has a Shopify collection external id. If not linked, the assignment is skipped; if linked, processing continues.
The Shopify collection id is resolved from the linked iPaaS.com category, and the Shopify product id from the linked iPaaS.com product.
On Add: the product is added to the Shopify collection.
On Delete: the product is removed from the Shopify collection.
Prerequisite note. Categories are linked to Shopify automatically — the iPaaS.com to Shopify Product Category collection links or creates the Shopify collection, and when a Product is imported into iPaaS.com the Product transfer auto-creates any of that product's categories that are not yet linked. Because of this, the category-link filter is a safety net rather than a manual step: subscribers do not need to sync categories first. The product link, however, must exist for the ProductId formula to resolve.
Mappings
Add Shopify Product Category Assignment FROM iPaaS.com
Mapping filter
var value = await GetExternalIdAsync(CategoryId, "Product Category", SpaceportSystemId);
if (value != null){return true;} else {return false;}The filter checks whether the category has been linked to a Shopify collection. If the category is not linked, the assignment is not processed.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Shopify) | Description |
Dynamic Formula |
| CollectionId | Required. Resolves the Shopify collection id from the linked iPaaS.com category. |
Dynamic Formula |
| ProductId | Required. Resolves the Shopify product id from the linked iPaaS.com product. |
Delete Shopify Product Category Assignment FROM iPaaS.com
Uses the same mapping filter and the same two Dynamic Formula mappings as the Add collection; together the resolved collection id and product id identify the assignment to remove.
Error Handling
Category not linked — the mapping filter skips the assignment; link the category to Shopify (it is linked automatically by the Product Category and Product transfers).
Invalid or unlinked product — if the ProductId formula cannot resolve a Shopify product id, the assignment cannot complete; sync the product to Shopify first.
Not found in Shopify — if the product or collection no longer exists in Shopify, Shopify returns a not-found error; review and retry.
Testing & Validation
Add an assignment in iPaaS.com for a product and a linked category, and confirm the product appears in the Shopify collection.
Delete the assignment and confirm the product is removed from the Shopify collection (product and collection still exist).
Add an assignment whose category is not yet linked to Shopify and confirm the transfer is skipped by the filter.
Confirm both CollectionId and ProductId resolve to valid Shopify ids before the assignment is sent.
Additional Notes
This mapping manages collection membership only — it does not create categories or products. Categories are created/updated by the iPaaS.com to Shopify Product Category collection, and products by the Product collections (see Related Documents).