Overview
This mapping documentation describes how Catsy product data is transferred into iPaaS.com. The Add/Update Catsy Product TO iPaaS.com collection creates or updates iPaaS.com Product records from Catsy Product data. It sets the product identity, name, description, pricing, status, category assignments, and a broad set of Catsy custom values so the iPaaS.com catalog stays aligned with Catsy.
A product is transferred together with its variants and options. When a Catsy product has variants, each variant is transferred as a child Product Variant record, and the option types and option values that organize those variants are transferred as child Product Option and Product Option Value records. Records are added when no matching iPaaS.com Product exists yet and updated when one is already linked.
ID Format
For Manual Sync, enter the Catsy product ID (its item ID). After a successful transfer, iPaaS.com saves the Catsy product ID as the external ID on a dedicated external-ID record for the product. Subsequent transfers use that link to route updates to the same iPaaS.com Product rather than creating a duplicate. On first sync, when no external-ID record exists yet, a Product with a matching Sku is linked instead.
Mapping Collection Status
Enabled. This collection has no mapping filter, so all Catsy product records are processed.
Supported Child Collections
A product is transferred with the following child collections:
Add/Update Catsy Product Variant TO iPaaS.com — the product's variants.
Add/Update Catsy Product Option TO iPaaS.com — the option types (for example, Size or Color) that variants are organized by.
Add/Update Catsy Product Option Value TO iPaaS.com — the individual choices under each option (for example, Small, Medium, or Large).
Child records are transferred as part of their parent product; there is no separate Manual Sync entry point for a variant, option, or option value on its own. To refresh a child record, re-sync its parent product.
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
Custom values: many destination fields are populated from Catsy additional properties. Each is transferred only when Catsy supplies a value for that property; otherwise the destination is left empty.
Type and Status constants: Type is always sent as Physical and Status is always sent as Active. Catsy does not drive these two values on a per-product basis.
iPaaS.com Caveats
Sku matching: when no external-ID link exists yet, the product is matched by Sku. Ensure the Catsy item ID is accurate so the correct iPaaS.com Product is reused.
Variant Sku uniqueness: each variant SKU must be unique within its product and must not match the parent product's SKU. Duplicate SKUs are rejected by iPaaS.com.
Numeric pricing: when a Catsy price value cannot be read as a number, the corresponding price field is written as 0.00. Confirm price values are numeric in Catsy so pricing transfers accurately.
Integration Flow
A Catsy product is created or updated, or a Manual Sync is triggered using the Catsy product ID.
The incoming product is matched to an existing iPaaS.com Product by its saved external ID, or by Sku when no external-ID link exists yet, so the existing record is updated rather than duplicated.
The Product record is created or updated in iPaaS.com with the mapped values.
Each of the product's variants is matched by Sku and created or updated as a child Product Variant, and the product's option types and option values are created or updated as child records linked to the product.
The Catsy product ID is saved as the external ID in iPaaS.com, and the transfer result is logged.
Mappings
Add/Update Catsy Product TO iPaaS.com
Description
This collection creates or updates iPaaS.com Product records from Catsy products. It maps the product SKU, name, description, pricing, status, tracking method, category assignments, and a broad set of Catsy custom values.
Mapping Type | Source (Catsy) | Destination (iPaaS.com) | Description |
Dynamic Formula | the Catsy product's item ID | Sku | Sets the iPaaS.com Product SKU and is also used to match and update the existing product rather than create a duplicate. Required. |
Dynamic Formula | the Catsy product name | Name | Sets the iPaaS.com Product name. Required. |
Static | the constant value Physical | Type | Sets the product type. Valid values are Physical and Virtual. Required. |
Dynamic Formula | the Catsy first price value, parsed as a number (0.00 when it cannot be read as a number) | DefaultPrice | Sets the product's default price. Required. |
Static | the constant value Active | Status | Sets the product status. Valid values are Preorder, Active, Disabled, and Discontinued. Required. |
Dynamic Formula | Product when the Catsy product has no variants, Variant when it has one or more | TrackingMethod | Sets how the product's inventory is tracked. Valid values are Product and Variant. Required. |
Dynamic Formula | the Catsy item description | Description | Sets the product description. Optional. |
Dynamic Formula | the Catsy category list, with the product's collections added, resolved to iPaaS.com category ids | Categories | Assigns the product to the matching iPaaS.com categories. As shipped, both categories and collections are assigned. Recommended. |
Dynamic Formula | the Catsy second price value, parsed as a number (0.00 when it cannot be read as a number) | price2 | Sets an additional price field. Optional. |
Dynamic Formula | the Catsy third price value, parsed as a number (0.00 when it cannot be read as a number) | price3 | Sets an additional price field. Optional. |
Dynamic Formula | the Catsy fourth price value, parsed as a number (0.00 when it cannot be read as a number) | price4 | Sets an additional price field. Optional. |
In addition to the core fields above, the following Catsy fields are captured into like-named iPaaS.com fields. Each is optional and is transferred only when Catsy supplies a value for that property:
Descriptive text: item_short_description, item_long_description, extended_desc, features, features_list, keywords, meta_title, meta_data, visibility.
Identity and classification: brand, manufacturer, manufacturer_product_name, product_type, product_group_sku, parent_item_id, upc, style, color, country_of_origin, catsy$option_attribute_keys.
Categorization: category_prime, category_2, category_5.
Dimensions: length, item_width, depth.
Pricing and catalog references: mfr_suggested_pricing_msrp, sales_pricing_unit_size, mfr_catalog_page, completeness_score.
Images and assets: main_image, secondary_image, product_image_4, product_image_5, product_image_6, product_image_7, product_image_8, product_image_9, AssetResource.
Add/Update Catsy Product Variant TO iPaaS.com
Description
This child collection creates or updates iPaaS.com Product Variant records from the parent product's Catsy variants. It maps the variant SKU, pricing, name, option selections, depth, and a range of custom values.
Mapping Type | Source (Catsy) | Destination (iPaaS.com) | Description |
Dynamic Formula | the variant's item ID, falling back to the variant's internal Catsy ID when it has no item ID | Sku | Sets the variant SKU and must not duplicate another variant or the parent product's SKU. Required. |
Dynamic Formula | the Catsy first price value, parsed as a number (0.00 when it cannot be read as a number) | DefaultPrice | Sets the variant's default price. Recommended. |
Dynamic Formula | the Catsy second price value, parsed as a number (0.00 when it cannot be read as a number) | SalePrice | Sets the variant's sale price. Recommended. |
Field | the Catsy variant's product name | Name | Sets the variant name so it is readable in iPaaS.com. Recommended. |
Field | the Catsy variant's option assignments | Options | Pairs each option with the variant's selected value so variants are distinguished by their option selections. Recommended. |
Dynamic Formula | the Catsy depth value when it is a whole number, otherwise 0 | Depth | Sets the variant depth. Optional. |
Field | the Catsy variant's internal ID | item_id | Records the variant's internal Catsy ID. Optional. |
In addition to the fields above, the following Catsy variant fields are captured into like-named iPaaS.com fields. Each is optional and is transferred only when Catsy supplies a value for that property: product_name, product_category_assignment, category_2, category_prime, item_desc, item_short_description, brand, features_list, product_group_sku, country_of_origin, parent_item_id, assets.
Add/Update Catsy Product Option TO iPaaS.com
Description
This child collection creates or updates iPaaS.com Product Option records from the parent product's Catsy option types — such as Size or Color — that the product's variants are organized by.
Mapping Type | Source (Catsy) | Destination (iPaaS.com) | Description |
Field | the Catsy option name (for example, Size or Color) | OptionName | Sets the product option name. Required. |
Add/Update Catsy Product Option Value TO iPaaS.com
Description
This child collection creates or updates iPaaS.com Product Option Value records from the parent product's Catsy option values — the individual choices under each option, such as Small, Medium, or Large under a Size option.
Mapping Type | Source (Catsy) | Destination (iPaaS.com) | Description |
Field | the Catsy option value (for example, Small, Medium, or Large) | Value | Sets the product option value. Required. |
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 Catsy product has an item ID so a Sku can be set, and the SKU is unique.
The product Name is present.
The first price value is numeric so DefaultPrice transfers accurately.
Each variant has a unique SKU that does not match the parent product's SKU, and its price values are numeric.
Option types and option values are present so variants can be distinguished by their selections.
After transfer, confirm the Product, its variants, and its options and option values appear in iPaaS.com with the expected category assignments.
Additional Notes
Deleted records: deleting a product, variant, option, or option value in Catsy is not propagated to iPaaS.com. See the Catsy Integration Known Limitations for details.
Tracking method: a product with no variants is transferred with TrackingMethod set to Product; a product with one or more variants is transferred with TrackingMethod set to Variant, and its variants are transferred through the child collection.