Overview
This mapping documentation describes how iPaaS.com product data is transferred into Catsy. The Add/Update Catsy Product FROM iPaaS.com collection creates or updates a Catsy Product from an iPaaS.com Product, so the Catsy catalog stays aligned with iPaaS.com.
The collection copies the product identifier, name, description, dimensions, pricing, and a broad set of custom values into like-named Catsy fields, and it resolves the product's tags and categories into Catsy. A record is added when no matching Catsy product exists yet, and updated when one is already linked by SKU.
ID Format
For Manual Sync, enter the iPaaS.com product ID. During the transfer the integration keys on the product's Sku to route the data to the matching Catsy product.
Updates are partial: only mapped values are sent, so any Catsy field that is not mapped in this collection is left unchanged. Where a mapped source value is empty, the corresponding Catsy field is left empty rather than being cleared with new data.
After a successful transfer, iPaaS.com saves the link to the Catsy product so subsequent transfers route updates to the same record rather than creating a duplicate.
Mapping Collection Status
Enabled. This collection has no mapping filter, so all iPaaS.com product records are processed.
Supported Child Collections
None. A product is transferred as a single record with no dependent child collections.
Custom Field Support
Catsy attributes are treated as custom fields in iPaaS.com. To use a Catsy attribute as a custom field, first create the attribute in Catsy, then register it on the iPaaS.com subscription.
Create the attribute in Catsy:
Log in to Catsy.
Navigate to Attributes > Attributes, then click New.
Select the desired Data Type and click Continue.
Enter the data type's details and click Continue.
Set the read/write access for each role and click Continue.
Choose the Attribute Group to add the attribute to and click Continue.
Select the Validation Level and click Continue.
Review your settings and click Finish to create the attribute.
Register the custom field on the iPaaS.com subscription:
Select the company where your Catsy subscription exists.
Navigate to Subscription Management > Subscription and click the Custom Field icon for your subscription.
On the Custom Fields page, click Add Custom Field.
In the Add New Custom Field dialog, enter the Name exactly matching the attribute key name in Catsy — the names must match.
Enter a Description.
Select the module for which you are creating the custom field, then click Save.
The custom field is now available to map in your flow.
System Caveats
Catsy Caveats
SKU matching: the transfer relies on the product SKU to locate the existing Catsy product or variant. Ensure SKUs are accurate so the correct Catsy record is reused rather than a duplicate being created.
Partial updates: only the values mapped in this collection are sent to Catsy. Fields that are not mapped keep whatever value they already hold in Catsy.
iPaaS.com Caveats
Custom field values: many destination fields are populated from iPaaS.com custom-field values. Where a source custom field is empty, the corresponding Catsy field is left empty.
Tags and categories: tag and category values are resolved dynamically. Tags are ensured to exist in Catsy before they are applied, and the product's assigned categories are resolved to the matching Catsy category before the primary category is set.
Integration Flow
An iPaaS.com product is created or updated, or a Manual Sync is triggered using the iPaaS.com product ID.
The incoming product is matched to an existing Catsy product or variant by its SKU so the correct record is updated rather than duplicated.
If no matching Catsy product exists, a new Catsy product is created; if one already exists, it is partially updated with the mapped values.
Referenced tags are ensured to exist in Catsy, and the product's assigned categories are resolved to their matching Catsy categories.
The link to the Catsy product is saved in iPaaS.com, and the transfer result is logged.
Mappings
Add/Update Catsy Product FROM iPaaS.com
Description
This collection creates or updates a Catsy Product from an iPaaS.com Product. It maps the product identifier, name, description, dimensions, and pricing, resolves the product's tags and categories, and copies a broad set of like-named custom values into Catsy.
Mapping Type | Source (iPaaS.com) | Destination (Catsy) | Description |
Field | the product's Sku | item_id | Sets the Catsy product identifier from the iPaaS.com product Sku. This is the value the transfer keys on to match and update the correct Catsy product. Recommended. |
Field | the product's Name | product_name | Sets the Catsy product name so the record has a readable name. Recommended. |
Field | the product's Description | item_desc | Sets the Catsy product description. Recommended. |
Field | the product's MSRP | mfr_suggested_pricing_msrp | Sets the Catsy manufacturer suggested retail price. Subscribers should validate this behavior in a staging environment before relying on it in production. |
Field | the product's Width | item_width | Sets the Catsy product width. Subscribers should validate this behavior in a staging environment before relying on it in production. |
Field | the product's Depth | depth | Sets the Catsy product depth. Subscribers should validate this behavior in a staging environment before relying on it in production. |
Dynamic Formula | the product's tag1 and tag2 values, ensured to exist in Catsy | tags | Builds the Catsy tag list from the iPaaS.com tag values. When both values are present, each tag is ensured to exist in Catsy, creating any that do not, and the tags are applied as a single list. When either value is missing, no tags are set. Recommended. |
Dynamic Formula | the product's assigned categories resolved to the matching Catsy category | category_prime | Sets the Catsy product's primary category. The first category in the product's category assignment is resolved to its Catsy category. When the product has no categories, no primary category is set. Recommended. |
Dynamic Formula | the product's category_2 custom value | category_2 | Sets the Catsy category_2 value. When the source value is empty, no value is set. Subscribers should validate this behavior in a staging environment before relying on it in production. |
Dynamic Formula | the product's category_5 custom value | category_5 | Sets the Catsy category_5 value. When the source value is empty, no value is set. Subscribers should validate this behavior in a staging environment before relying on it in production. |
In addition to the core fields above, this collection copies a broad set of iPaaS.com product fields and custom values into like-named Catsy fields. Each is a direct field copy, and where a source value is empty the corresponding Catsy field is left empty. Subscribers should validate these behaviors in a staging environment before relying on them in production. The following iPaaS.com values are captured into like-named Catsy fields:
brand, manufacturer, manufacturer_product_name
country_of_origin, product_group_sku, product_type, style
features, features_list, item_long_description, keywords, meta_data
color, visibility, main_image, length, upc
price1, price2, price3, price4
Error Handling
Errors encountered during product transfers appear in the iPaaS.com Dashboard under Integration Monitoring and in the Error Logs. For the full list of product errors, their causes, and resolutions, see the Catsy Error Messages article.
Validation and Testing
Validation Checklist
The iPaaS.com product has a valid Sku so it resolves to the correct Catsy product or variant.
Only one Catsy product exists per SKU, so updates route to a single record rather than creating a duplicate.
The category values assigned on the product exist in Catsy so the primary category resolves correctly.
After transfer, confirm the product appears in Catsy with the expected identifier, name, and mapped values.
Additional Notes
Deleted records: deleting a product in iPaaS.com is not propagated to Catsy. See the Catsy Integration Known Limitations for details.
Partial updates: because only mapped values are sent, values that are not mapped in this collection remain unchanged in Catsy.