Skip to main content

iPaaS.com to Linnworks Inventory Mapping Documentation

How iPaaS.com inventory maps to Linnworks stock levels for products and variants, by location.

Summary

iPaaS.com inventory records set stock levels in Linnworks for products and for product variants, matched to the correct Linnworks stock location. Separate collections handle adding and updating product stock levels and variant stock levels.

ID Format

Manual Sync ID Format. On the iPaaS.com Manual Sync page, enter the iPaaS.com product inventory identifier (or the variant inventory identifier) to transfer a single stock level on demand.

External ID Format. The stock level is applied to the Linnworks product or variant identified by its SKU at the matched location; no separate external-ID record is required to set a level.

Deleted Record Support

Outbound delete is not supported. Inventory records are set or updated only; delete mappings are not included in the default templates.

Mapping Collection Status

Enabled. A stock level is transferred only when the iPaaS.com location maps to an existing Linnworks location (see the filter below). Separate Add and Update collections exist for product inventory and for variant inventory.

Duplicate or Conflicting Mappings

Product inventory and product variant inventory are handled by separate collections, each with an Add and an Update variant. They operate on different entities (products versus variants) and do not conflict.

System Caveats

Linnworks Caveats

  • The iPaaS.com location must correspond to an existing Linnworks stock location by name. Records for a location with no Linnworks match are skipped.

  • The product or variant identified by the SKU must already exist in Linnworks for the stock level to be applied.

Integration Flow

  1. For each inventory record, the integration converts the iPaaS.com location to the matching Linnworks location and confirms it exists; if it does not, the record is skipped.

  2. The integration identifies the Linnworks product or variant by its SKU.

  3. The stock level (quantity on hand) is set for that item at that location.

Mappings

Add Linnworks Product Inventory FROM iPaaS.com / Update Linnworks Product Inventory FROM iPaaS.com

The Add and Update collections share the same mappings and filter; they differ only in whether they run on an add or an update.

Mapping Filter

string locationName = await ConvertIPaaSLocationIdToLinnworksLocationNameAsync(LocationId);
string linnworksLocationId = await GetLinnworksLocationIdByNameAsync(locationName);
if(string.IsNullOrWhiteSpace(linnworksLocationId))
    return false;
return true;

Filter Description. A stock level is transferred only when the iPaaS.com location maps to an existing Linnworks location. When no matching Linnworks location is found, the record is skipped so stock is never written to an unknown location.

Mapping Type

Source Field (iPaaS.com)

Destination Field (Linnworks)

Description

Dynamic Formula

Product identifier

SKU

Required. Resolves the iPaaS.com product to its Linnworks SKU.

Dynamic Formula

Location

LocationId

Required. Resolves the iPaaS.com location to its Linnworks location.

Field

QtyOnHand

Level

Required. The stock quantity on hand to set in Linnworks.

Add Linnworks Product Variant Inventory FROM iPaaS.com / Update Linnworks Product Variant Inventory FROM iPaaS.com

The Add and Update collections share the same mappings and filter; they apply to product variants.

Mapping Filter

string locationName = await ConvertIPaaSLocationIdToLinnworksLocationNameAsync(LocationId);
string linnworksLocationId = await GetLinnworksLocationIdByNameAsync(locationName);
if(string.IsNullOrWhiteSpace(linnworksLocationId))
    return false;
return true;

Filter Description. A variant stock level is transferred only when the iPaaS.com location maps to an existing Linnworks location; otherwise the record is skipped.

Mapping Type

Source Field (iPaaS.com)

Destination Field (Linnworks)

Description

Dynamic Formula

Variant identifier

SKU

Required. Resolves the iPaaS.com variant to its Linnworks variant SKU.

Dynamic Formula

Location

LocationId

Required. Resolves the iPaaS.com location to its Linnworks location.

Field

QtyOnHand

Level

Required. The stock quantity on hand to set in Linnworks.

Testing & Validation

  1. Transfer a stock level for a product at a location that exists in Linnworks and verify the Linnworks stock level updates.

  2. Transfer a stock level for a location that does not exist in Linnworks and confirm the record is skipped.

  3. Transfer a variant stock level and verify the variant's Linnworks stock level updates.

  4. Manually sync an inventory record by its iPaaS.com identifier and confirm it transfers.

Additional Notes

  • Outbound delete is not supported (see Deleted Record Support).

  • Product and variant records themselves are transferred by the separate Linnworks Product collections.

Related Documents

Did this answer your question?