Skip to main content

iPaaS.com to Linnworks Product Mapping Documentation

How iPaaS.com products and variants map to Linnworks inventory items, including variation groups.

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

  1. 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.

  2. 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.

  3. For a product with variations, the variation group is created and its variants are added, each variant transferred by the Product Variant collection.

  4. 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

  1. Transfer a single (non-variation) product from iPaaS.com and verify it is created in Linnworks with its SKU, name, price, and category.

  2. Transfer a product that uses variations and verify the variation-group product and its variants are created in Linnworks.

  3. Re-transfer an existing product and verify the existing Linnworks item is updated rather than duplicated.

  4. 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.

  5. 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.

Related Documents

Did this answer your question?