Summary
iPaaS.com products are created and updated in Linnworks as inventory items. Single products are handled by one collection, products that use variations by another, and the individual variants by a third. Together they keep the Linnworks catalog aligned with iPaaS.com products.
ID Format
Manual Sync ID Format. On the iPaaS.com Manual Sync page, enter the iPaaS.com product identifier (for a variant, the iPaaS.com variant identifier) to transfer a single product on demand.
External ID Format. After a successful transfer, the Linnworks stock item identifier is recorded as the external ID for the product (or variant). On a later transfer, the integration uses this link to update the existing Linnworks item instead of creating a duplicate.
Deleted Record Support
Outbound delete is not supported. Removing a product in iPaaS.com does not delete the corresponding Linnworks item, and delete mappings are not included in the default templates.
Mapping Collection Status
Enabled. Products are routed by their mapping filters: products without variations are handled by one collection, and products with variations by another. Variants are handled by their own collection.
Duplicate or Conflicting Mappings
Two product collections operate on the same entity and are separated by their filters so that each product is handled once:
Add/Update Linnworks Product Without Variants FROM iPaaS.com handles single products.
Add/Update Linnworks Product With Variants FROM iPaaS.com handles products that use variations.
Review both filters before changing either. To prevent duplicates, the integration matches an incoming product or variant to an existing Linnworks item by SKU and links to it (updating the existing item) rather than creating a new one.
Supported Child Collections
Add/Update Linnworks Product Variant FROM iPaaS.com: transfers the individual variants that belong to a variation-group product.
System Caveats
Linnworks Caveats
The product category is set only when the iPaaS.com category name matches an existing Linnworks category; otherwise it is left unset.
The purchase price is taken from the first inventory record at a valid Linnworks location that has a cost greater than zero; if none is available, the purchase price is left unset.
iPaaS.com Caveats
A product's SKU is its unique identifier in Linnworks and must be present for the product to be created or matched.
For products that use variations, the variation group (parent) must be established so its variants attach correctly.
Integration Flow
A product transfer is routed by its filter: products without variations go to the single-product collection, and products with variations to the variation-parent collection.
The integration looks up the product in Linnworks by SKU. If it already exists, the existing item is updated; otherwise a new inventory item is created.
For a product with variations, the variation group is created and its variants are added, each variant transferred by the Product Variant collection.
The update is built from the values you have mapped and sent to Linnworks; the integration does not read and merge the existing Linnworks item first, so map every field you want kept populated (see the Known Limitations article for update-overwrite guidance).
Mappings
Add/Update Linnworks Product Without Variants FROM iPaaS.com
Mapping Filter
if (TrackingMethod == "Product" || Variants == null || Variants.Count == 0)
{
return true;
}Filter Description. Only products without variations are transferred by this collection — a product tracked as a single item, or a product with no variants. Products that use variations are handled by the companion collection and are skipped here.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Linnworks) | Description |
Field | Sku | ItemNumber | Required. The product SKU, its unique identifier in Linnworks. |
Field | Name | ItemTitle | Required. The product name. |
Field | Barcode | BarcodeNumber | Recommended. The product barcode. |
Static | "false" | IsVariationParent | Required. Fixed; these products have no variations. |
Dynamic Formula | Inventory cost | PurchasePrice | Recommended. First valid-location cost greater than zero. |
Field | DefaultPrice | RetailPrice | Recommended. The retail price. |
Field | TaxClass | TaxRate | Recommended. The tax rate. |
Dynamic Formula | Category name | CategoryId | Recommended. Matched to an existing Linnworks category. |
Field | Height | Height | Recommended. Product height. |
Field | Width | Width | Recommended. Product width. |
Field | Depth | Depth | Recommended. Product depth. |
Field | Weight | Weight | Recommended. Product weight. |
Dynamic Formula | Inventory presence | InventoryTrackingType | Inventory tracking on when the product has inventory, off otherwise. |
Dynamic Formula | External ID lookup | StockItemId | Links to an existing Linnworks item for updates. |
Add/Update Linnworks Product With Variants FROM iPaaS.com
Mapping Filter
if (Variants != null && Variants.Count > 0)
{
return true;
}Filter Description. Only products that have one or more variations are transferred by this collection. Products without variations are handled by the companion collection and are skipped here.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Linnworks) | Description |
Field | Sku | ItemNumber | Required. The product SKU. |
Field | Name | ItemTitle | Required. The product name. |
Field | Barcode | BarcodeNumber | Recommended. The product barcode. |
Dynamic Formula | Inventory cost | PurchasePrice | Recommended. First valid-location cost greater than zero. |
Field | DefaultPrice | RetailPrice | Recommended. The retail price. |
Field | TaxClass | TaxRate | Recommended. The tax rate. |
Dynamic Formula | Category name | CategoryId | Recommended. Matched to an existing Linnworks category. |
Static | "2" | InventoryTrackingType | Required. Fixed; configures tracking for a variation-parent product. |
Field | Name | VariationGroup_VariationGroupName | Required. The variation group name. |
Field | Sku | VariationGroup_ParentSku | Required. The parent SKU grouping the variations. |
Add/Update Linnworks Product Variant FROM iPaaS.com
This collection has no mapping filter; every variant presented is processed.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Linnworks) | Description |
Field | Sku | ItemNumber | Required. The variant SKU, its unique identifier in Linnworks. |
Dynamic Formula | Parent name | ItemTitle | Recommended. Taken from the parent product name. |
Field | Barcode | BarcodeNumber | Recommended. The variant barcode. |
Static | "true" | IsVariationParent | Required. Fixed for records in this collection. |
Dynamic Formula | Inventory cost | PurchasePrice | Recommended. First valid-location cost greater than zero. |
Field | DefaultPrice | RetailPrice | Recommended. The retail price. |
Dynamic Formula | Parent tax class | TaxRate | Recommended. Taken from the parent product. |
Dynamic Formula | Category name | CategoryId | Recommended. Matched to an existing Linnworks category. |
Field | Height | Height | Recommended. Variant height. |
Field | Width | Width | Recommended. Variant width. |
Field | Depth | Depth | Recommended. Variant depth. |
Field | Weight | Weight | Recommended. Variant weight. |
Dynamic Formula | (configured) | InventoryTrackingType | Sets the variant's inventory tracking type. |
Dynamic Formula | External ID lookup | StockItemId | Links to an existing Linnworks variant for updates. |
Testing & Validation
Transfer a single (non-variation) product from iPaaS.com and verify it is created in Linnworks with its SKU, name, price, and category.
Transfer a product that uses variations and verify the variation-group product and its variants are created in Linnworks.
Re-transfer an existing product and verify the existing Linnworks item is updated rather than duplicated.
Transfer a product whose category name matches a Linnworks category and verify the category is set; transfer one whose category does not match and verify the category is left unset.
Manually sync a product by its iPaaS.com identifier and confirm it transfers.
Additional Notes
Outbound delete is not supported (see Deleted Record Support).
Stock levels are transferred by the separate Linnworks Product Inventory and Product Variant Inventory collections.
