Overview
An iPaaS Product can be transferred to Catsy using an Add sync method. This mapping supports the automated synchronization of product records from iPaaS into Catsy as a product.
Custom Field Support
Catsy attributes are treated as custom fields in iPaaS. Follow these steps for custom field support.
Log in to Catsy using your credentials.
Navigate to Attributes > Attributes (A), then click New (B).
On the next page, select the desired Data Type and then click Continue.
On the net page enter the data type's details. Click Continue.
Select the read/write access for each role and click Continue.
Choose the Attribute Group to add this data type to and click Continue.
Select the Validation Level for the attribute and click Continue.
Review your settings. If you need to make changes, click Previous. Click Finish to create the attribute.
To map this custom field from Catsy within the integration flow, you must first map it manually in the Catsy subscription on iPaaS. Follow the steps below to complete this process.
Log in to your iPaaS account.
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 box, enter the Name exactly the same as the attribute key name in Catsy. The name must match.
Enter a Description.
Select the module for which you are creating the custom field, then click Save.
You can now map the custom field in your flow.
Integration Flow
Product Creation: A new Product record is created in Catsy with the mapped details.
Product Resolution: The system finds the corresponding Product in Catsy using their external ID or sku.
Product Variant Resolution: The system finds the corresponding Product variant in Catsy using their external ID or sku.
Integration Settings
Mapping Status: Enabled.
ID Format: When manually syncing, the Product ID from iPaaS is used. This can be resolved via an external ID or the Product sku.
Conflicting Mappings: This mapping applies only to Product. Ensure no other mappings target the same Catsy entity to prevent data from being overwritten.
Authentication & Security
Catsy uses API key authentication to generate an access token, which is then used to authorize all Catsy API requests in transfer operations.
Mappings
Product From iPaaS
Mapping Type | Source (iPaaS.com) | Destination (Catsy) | Description |
Field | Sku | item_id (Custom Field) | Required: The iPaaS Sku will be added to the item_id custom field of the Catsy Product. |
Field | Name | product_name (Custom Field) | The iPaaS Name will be added to the product_name custom field of the Catsy Product. |
Field | Depth | depth (Custom Field) | The iPaaS Name will be added to the depth custom field of the Catsy Product. |
Field | Description | Item_desc (Custom Field) | The iPaaS Description will be added to the item_desc custom field of the Catsy Product. |
Field | Width | item_width (Custom Field) | The iPaaS Width will be added to the item_width custom field of the Catsy Product. |
Field | MSRP | mfr_suggested_pricing_msrp (Custom Field) | The iPaaS MSRP will be added to the mfr_suggested_pricing_msrp custom field of the Catsy Product. |
Field | Brand (Custom Field) | brand (Custom Field) | The iPaaS Brand Custom Field will be added to the brand custom field of the Catsy Product. |
Field | feature_list (Custom Field) | feature_list (Custom Field) | The iPaaS feature_list Custom Field will be added to the feature_list custom field of the Catsy Product. |
Field | country_of_origin (Custom Field) | country_of_origin (Custom Field) | The iPaaS country_of_origin Custom Field will be added to the country_of_origin custom field of the Catsy Product. |
Field | product_group_sku (Custom Field) | product_group_sku (Custom Field) | The iPaaS product_group_sku Custom Field will be added to the product_group_sku custom field of the Catsy Product. |
Field | manufacturer_product_name (Custom Field) | manufacturer_product_name (Custom Field) | The iPaaS manufacturer_product_name Custom Field will be added to the manufacturer_product_name custom field of the Catsy Product. |
Field | Keywords (Custom Field) | Keywords (Custom Field) | The iPaaS Keywords Custom Field will be added to the Keywords custom field of the Catsy Product. |
Field | features(Custom Field) | features(Custom Field) | The iPaaS features Custom Field will be added to the features custom field of the Catsy Product. |
Field | visibility (Custom Field) | visibility (Custom Field) | The iPaaS visibility (Custom Field) will be added to the visibility (Custom Field) of the Catsy Product. |
Field | color(Custom Field) | color(Custom Field) | The iPaaS color (Custom Field) will be added to the color (Custom Field) of the Catsy Product. |
Field | main_image (Custom Field) | main_image (Custom Field) | The iPaaS main_image (Custom Field) will be added to the main_image Custom Field of the Catsy Product. |
Field | length (Custom Field) | length (Custom Field) | The iPaaS length (Custom Field) will be added to the length Custom Field of the Catsy Product. |
Field | product_type (Custom Field) | product_type (Custom Field) | The iPaaS product_type (Custom Field) will be added to the product_type (Custom Field) of the Catsy Product. |
Field | item_long_description (Custom Field) | item_long_description (Custom Field) | The iPaaS item_long_description (Custom Field) will be added to the item_long_description Custom Field of the Catsy Product. |
Field | upc (Custom Field) | upc (Custom Field) | The iPaaS upc Custom Field will be added to the upc custom field of the Catsy Product. |
Field | style (Custom Field) | style (Custom Field) | The iPaaS style Custom Field will be added to the style custom field of the Catsy Product. |
Field | manufacturer (Custom Field) | manufacturer (Custom Field) | The iPaaS manufacturer Custom Field will be added to the manufacturer Custom Field of the Catsy Product. |
Field | meta_data (Custom Field) | meta_data (Custom Field) | The iPaaS meta_data Custom Field will be added to the meta_data Custom Field of the Catsy Product. |
Field | price1 (Custom Field) | price1 (Custom Field) | The iPaaS price1 Custom Field will be added to the price1 Custom Field of the Catsy Product. |
Field | price2 (Custom Field) | price2 (Custom Field) | The iPaaS price2 Custom Field will be added to the price2 Custom Field of the Catsy Product. |
Field | Price3 (Custom Field) | Price3 (Custom Field) | The iPaaS price3 Custom Field will be added to the price3 Custom Field of the Catsy Product. |
Field | Price4 (Custom Field) | Price4 (Custom Field) | The iPaaS price4 Custom Field will be added to the price4 Custom Field of the Catsy Product. |
Dynamic Formula |
| tags | Tags are created from the custom field where we get the tag1 and tag2 and so on first the tags are converted to list, if it exists, they are returned if it does not exist it creates first then returns it. |
Dynamic Formula |
| Category_prime | Categories are assigned on the basis of a specific category ID based on the provided index or the last Category Id in the list from the Product Category Assignment |
Dynamic Formula |
| category_5 | Retrieves the value of the custom field named "category_5" from the CustomFields collection using the |
Dynamic Formula |
| category_2 | Retrieves the value of the custom field named "category_2" from the CustomFields collection using the |
Error Handling
Collection: Product
Missing Product ID or SKU
Product cannot be resolved because the external ID or SKU is missing.
Resolution: Ensure that the Product ID or SKU exists in iPaaS and is correctly mapped to Catsy.
Invalid Custom Field Mapping
Custom field in Catsy does not exist or is misconfigured.
Resolution: Verify that all required custom fields (e.g., item_id, product_name, depth, item_desc, item_width, etc.) are created in Catsy and their names exactly match the keys in iPaaS.
Category Assignment Failure
Category mapping fails if Categories list is null or incorrect.
Resolution: Ensure that Categories exist in Catsy and that the mapping formula retrieves valid Catsy category IDs.
Validation Rules & Testing
Validation Rules
Product Identification
Product must have a valid external ID or SKU to resolve in Catsy.
Duplicate products must be avoided; only one product per external ID/SKU.
Custom Fields
All mapped custom fields must exist in Catsy.
Field names must match exactly between iPaaS and Catsy.
Dynamic formulas (tags, categories, category_2, category_5) must return valid values.
Category Mapping
Categories assigned must exist in Catsy and follow the correct index logic in the mapping formula.
Validation Checklist
Product ID is resolved (via external ID or Sku).
Test Scenarios
Valid Product: Syncs successfully.
Invalid Product ID: The Product is rejected, and an error is logged.
Additional Notes
Catsy requires all custom fields to be manually created in Catsy before mapping.