Summary

iPaaS.com products that have no variants can be written to Square as catalog items. Because Square requires every item to have at least one variation, this collection also creates a single default variation carrying the product's price, currency, barcode, and stock status. It handles products tracked at the product level, keeping the Square item aligned with iPaaS.com as the product changes. Products that have variants are handled by the companion iPaaS.com to Square Product (With Variants) documentation instead.

Note on amounts: Square records money in the smallest unit of the currency (for example, cents). Price mappings multiply the iPaaS.com decimal price by 100 to send the amount Square expects.

Note on fixed values: Several fields carry fixed Square catalog keywords (for example, ITEM, ITEM_VARIATION, FIXED_PRICING). These are case-sensitive Square values and should not be changed.

ID Format

Manual Sync ID: the iPaaS.com product identifier, entered on the iPaaS.com Manual Sync page.
External ID saved after sync: on the first successful transfer, iPaaS.com records the Square catalog item identifier and catalog version as the external ID for the product. That external ID routes later updates to the same Square item and supplies the catalog version Square needs to accept an update.

Deleted Record Support

Outbound product deletion is not supported. The Square Product model's Delete operation is not implemented, delete mappings are not included in the default templates, and deleting a product in iPaaS.com does not remove the corresponding Square item.

Mapping Collection Status

Status: Enabled, with a mapping filter that limits this collection to products tracked at the product level that have no variants (see Mappings).
Trigger Events: the iPaaS.com product Create and Update outbound triggers, enabled by subscribers or their MiSP in the subscription's Outbound Data Flows configuration. Products can also be written on demand from the Manual Sync page.

Duplicate or Conflicting Mappings

Related Collection

iPaaS.com to Square Product (With Variants) targets the same Square product catalog. The two collections are kept apart by their filters — this one handles products without variants, the other handles products with variants. Important: review both filters before enabling so that each product is written by exactly one of them.

Existing-Item Matching

Before writing, the integration looks for an existing Square item with the same SKU and links the iPaaS.com product to it, so an update is applied instead of creating a duplicate. If the link cannot be completed, the transfer stops and records an error.

System Caveats

Square Caveats

Money amounts are in the smallest unit of the currency. The iPaaS.com price is converted to the smallest unit (for example, cents) that Square expects.
Currency must match your Square account. The price currency ships as USD; if your Square account is not in US dollars, the item is rejected until the currency is changed (see the placeholder callout under Mappings).
Fixed catalog keywords are case-sensitive. The item and variation types and the pricing type use exact Square keywords and must not be changed.
Stock status comes from product status. An Active product is stockable; Disabled or Preorder is not.
Categories must already exist in Square. Category assignment matches iPaaS.com categories to existing Square categories by name and full parent chain; categories with no exact match are left off.
Rate limiting: if Square temporarily limits requests, the transfer is automatically rescheduled to resume after the limit resets. No subscriber action is required.

iPaaS.com Caveats

The Square item name is set from the product SKU. If you want a different name on the Square item, remap the name to the iPaaS.com product name field.

Setup Requirements

iPaaS.com Configuration

Enable the iPaaS.com product Create and Update outbound triggers in the subscription configuration's Outbound Data Flows section. No products transfer automatically until those triggers are enabled. Products can also be written on demand from the Manual Sync page using the iPaaS.com product identifier. Before enabling this collection, replace the USD currency placeholder (see Mappings) if your Square account uses a different currency.

Square Configuration

The Square connection must be authorized for the integration. To file products under categories, create the matching Square category hierarchy first (see the Categories mapping description below).

Integration Flow

An iPaaS.com product is written to Square via the product Create or Update outbound trigger, or on Manual Sync using the iPaaS.com product identifier.
The collection filter admits only products tracked at the product level that have no variants.
The integration looks for an existing Square item with the same SKU; if one exists, it links the iPaaS.com product to that Square item so the write becomes an update, otherwise it creates a new item.
The Square catalog item is written together with its single default variation (price, currency, stock status, barcode).
Categories are assigned by matching the product's iPaaS.com categories to existing Square categories by name and full parent chain.
The Square catalog item identifier and version are saved as the external ID.

Mappings

Add/Update Square Product Without Variants FROM iPaaS.com

iPaaS.com data type: Product

Mapping Filter

TrackingMethod == "Product" && Variants?.Count == 0

Filter Description. The collection processes a product only when it is tracked at the product level (TrackingMethod == "Product") and carries no variants (Variants?.Count == 0). Products tracked at the variant level, or that have one or more variants, are skipped here and handled by the iPaaS.com to Square Product (With Variants) collection instead.

Mapping Type	Source (iPaaS.com)	Destination (Square)	Description
Static	`"ITEM"`	Type	Required. Identifies the catalog object as a product item; must remain `ITEM` (case-sensitive).
Field	Sku	Name	Required. Square requires a name to create an item; it is set from the iPaaS.com product SKU. Remap to the product name field to show a different name.
Field	Description	Description	Recommended. The product's plain-text description.
Field	Description	DescriptionHtml	Recommended. The product's description in Square's rich-text (HTML) field.
Dynamic Formula	Dynamic Formula	Categories	Optional. Matches the product's iPaaS.com categories to existing Square categories by name and full parent chain; unmatched categories are left off.
Dynamic Formula	`return true;`	PresentAtAllLocations	Recommended. Makes the item available at all Square locations.
Dynamic Formula	`"#simple_" + Name`	DefaultVariation_Id	Required. A temporary reference for the single default variation while the item is created (Square requires the number-sign prefix).
Static	`"ITEM_VARIATION"`	DefaultVariation_Type	Required. Identifies the default variation as an item variation; must remain `ITEM_VARIATION` (case-sensitive).
Static	`"FIXED_PRICING"`	DefaultVariation_PricingType	Required. Sets fixed pricing on the default variation; must remain `FIXED_PRICING` (case-sensitive).
Dynamic Formula	`DefaultPrice * 100`	DefaultVariation_PriceMoney_Amount	Required. The default variation price, from the iPaaS.com default price converted to the smallest currency unit.
Static	`"USD"`	DefaultVariation_PriceMoney_Currency	Required. The currency of the default variation price. Placeholder value — replace during implementation: ships as `USD`; if your Square account is not in US dollars, replace it with your account's currency code before enabling this collection, or Square rejects the item.
Lookup Translation	Lookup Translation: Square Product Variant (Default) Status From iPaaS	DefaultVariation_Stockable	Recommended. Sets whether the default variation is stockable, from the iPaaS.com product status (see the translation table below).
Field	Barcode	DefaultVariation_Upc	Optional. The iPaaS.com product barcode, written to the default variation's UPC.

Lookup Translation Tables

Square Product Variant (Default) Status From iPaaS:

Source Value (iPaaS.com)	Destination Value (Square)	Notes
Active	true	Stockable in Square.
Disabled	false	Not stockable.
Preorder	false	Not stockable.

Adjust these entries if your product statuses should map to stockability differently.

Error Handling

Product link could not be completed: when the integration finds (or creates) a Square item but cannot save the external-ID link, the transfer stops and records an error noting that duplicate product records may otherwise result. See the Square Error Messages article for the full message text and resolution steps.
Currency mismatch: if the USD currency does not match your Square account, Square rejects the item; set the currency to your account's currency (see the placeholder callout under Mappings).

Testing & Validation

Write an iPaaS.com product that has no variants and confirm a Square catalog item is created with a single default variation carrying the correct price, currency, and barcode.
Confirm the Square item name matches the iPaaS.com product SKU (or your remapped name field).
Confirm an Active product's default variation is stockable and a Disabled or Preorder product's is not.
Assign the product to an iPaaS.com category that also exists in Square (with the same parent chain) and confirm it is filed under the matching Square category; confirm an unmatched category is left off.
Re-write the same product and confirm it updates the existing Square item rather than creating a duplicate.

Additional Notes

Deletion is out of scope. Deleting a product in iPaaS.com does not remove the corresponding Square item.

iPaaS.com to Square Product (Without Variants) Mapping Documentation