Shopify to iPaaS.com Product Mapping Documentation
This documentation covers the mapping collections that bring Shopify products and their related data — inventory, options, option values, variants, and variant inventory — into iPaaS.com (the TO iPaaS.com direction). The parent collection reads a Shopify product and creates or updates the matching iPaaS.com Product; its child collections import the product's inventory, options, option values, variants, and variant inventory. Together they keep iPaaS.com aligned with Shopify's catalog structure, inventory availability, and variant definitions, for both new products and updates.
The opposite direction — writing iPaaS.com products to Shopify — is covered in iPaaS.com to Shopify Product Mapping Documentation.
ID Format
Manual Sync ID: the Shopify product id. Enter it on the iPaaS.com Manual Sync page to import that product.
External ID: after a successful import, the Shopify product id is saved as the external-id link so later transfers update the same iPaaS.com Product rather than creating a duplicate.
Deleted Record Support
Product deletion is not handled in the TO iPaaS.com direction by these collections. There is no Shopify-to-iPaaS.com product delete collection. (Product deletion in the other direction — removing a Shopify product when an iPaaS.com product is deleted — is handled by the Delete Shopify Product FROM iPaaS.com collection.)
Mapping Collection Status
All collections in this direction are Enabled.
Trigger events: Product Created or Product Updated in Shopify (products/create, products/update), enabled under the subscription's Inbound Data Flows. Manual Sync is always available.
Duplicate or Conflicting Mappings
These TO iPaaS.com collections import products from Shopify. The companion FROM iPaaS.com collections (Add Shopify Product FROM iPaaS.com, Update Shopify Product FROM iPaaS.com, Delete Shopify Product FROM iPaaS.com) write products to Shopify. Because the iPaaS.com API replaces the whole record on update, importing a product through this direction rewrites the mapped iPaaS.com Product fields each run.
Warning — Unmapped Field Overwrite Risk: The iPaaS.com API uses PUT (full record replace) when updating Product records. Any iPaaS.com Product field not mapped in the parent collection is overwritten with empty/null each time the collection runs. Add preservation mappings (a Dynamic Formula sourcing the field from the existing record, e.g. DestinationValue.<field>) for any iPaaS.com-side fields maintained outside this integration.
Supported Child Collections
Parent Collection: Add/Update Shopify Product TO iPaaS.com
Add/Update Shopify Product Inventory TO iPaaS.com — imports product inventory levels.
Add/Update Shopify Product Option TO iPaaS.com — imports product options.
Add/Update Shopify Product Option Values TO iPaaS.com — imports option values (child of the Option collection).
Add/Update Shopify Product Variant TO iPaaS.com — imports product variants.
Add/Update Shopify Product Variant Inventory TO iPaaS.com — imports variant inventory levels (child of the Variant collection).
System Caveats
Shopify Caveats
Simple products carry default option/value placeholders ("Title" / "Default Title"); the Option and Option Values collections filter these out so they are not imported as real options.
Gift card products are not imported as standard products in this flow.
TrackingMethod is not returned by the Shopify GraphQL API — the integration derives it ("Variant" when the product has variants, "Product" for a simple product).
iPaaS.com Caveats
The product Status import relies on a configured Lookup Translation; confirm it is set for your store's status values.
Inventory import requires the Shopify location to resolve to an existing iPaaS.com Location.
Full-record replace on update — see the overwrite warning above.
Setup Requirements
Enable the Add/Update Shopify Product TO iPaaS.com collection and the child collections you need (Inventory, Option, Option Values, Variant, Variant Inventory).
Configure the Lookup Translation for product Status.
Enable the Shopify Product Created / Product Updated inbound events under Inbound Data Flows.
The Shopify connection must include the
read_productsscope (andread_inventoryfor the inventory collections).
Integration Flow
A Shopify product webhook (create/update) or a manual sync triggers the parent import.
Core product fields are written to the iPaaS.com Product, linked by the Shopify product id.
Child collections import inventory, options (and their values), and variants (and their inventory).
Option/option-value placeholders for simple products are filtered out.
Mappings
Add/Update Shopify Product TO iPaaS.com (Parent) — Collection 284604
Mapping Type | Source Field (Shopify) | Destination Field (iPaaS.com) | Notes |
Dynamic Formula |
| Shopify Images (custom) | Image data as |
Field | InventoryPolicy | Inventory Policy (custom) | |
Field | InventoryLevel_Tracked | Inventory Tracked (custom) | Replaces deprecated |
Dynamic Formula |
| test dani (custom) | Placeholder — replace |
Field | InventoryLevel_RequiresShipping | Requires Shipping (custom) | Replaces deprecated |
Dynamic Formula |
| Shopify Product Channels (custom) | Channel ids → comma-separated channel names. |
Field | SKU | Sku | Required. Simple products return the default variant SKU; variant products return |
Field | BodyHtml | Description | Recommended. |
Dynamic Formula |
| Type | "Physical" for variant/simple; "Virtual" when inventory management is null. |
Field | Price | DefaultPrice | Recommended. |
Field | Barcode | Barcode | Recommended. |
Field | Title | Name | Required. |
Lookup Translation | Shopify product status | Status | Configure the lookup. |
Field | Weight | Weight | Recommended. |
Dynamic Formula |
| Categories | Verifies Shopify categories exist in iPaaS.com. |
Field | TrackingMethod | TrackingMethod | Derived by the integration, not the Shopify API. |
Add/Update Shopify Product Inventory TO iPaaS.com (Child) — Collection 284639
Mapping Type | Source Field (Shopify) | Destination Field (iPaaS.com) | Notes |
Field | FulfillmentService | FulFillment Service (custom) | |
Dynamic Formula |
| LocationId | Resolves the iPaaS.com Location id from the Shopify location id. |
Field | Available | QtyAvailable | Required. |
Add/Update Shopify Product Option TO iPaaS.com (Child) — Collection 284640
Mapping filter: Name != "Title" — excludes the default simple-product option placeholder.
Mapping Type | Source Field (Shopify) | Destination Field (iPaaS.com) |
Field | Name | OptionName |
Field | Position | Order |
Add/Update Shopify Product Option Values TO iPaaS.com (Option's Child) — Collection 284648
Mapping filter: Value != "Default Title" — excludes the default simple-product value placeholder.
Mapping Type | Source Field (Shopify) | Destination Field (iPaaS.com) |
Field | Value | Value |
Add/Update Shopify Product Variant TO iPaaS.com (Child) — Collection 284641
Mapping Type | Source Field (Shopify) | Destination Field (iPaaS.com) | Notes |
Field | InventoryPolicy | Inventory Policy (custom) | |
Field | InventoryLevel_Tracked | Inventory Tracked (custom) | |
Field | InventoryLevel_RequiresShipping | Requires Shipping (custom) | |
Field | Barcode | Barcode | |
Field | Price | DefaultPrice | Recommended. |
Field | SKU | Sku | Required. |
Field | Weight | Weight | |
Field | VariantOptions | Options | Recommended. |
Add/Update Shopify Product Variant Inventory TO iPaaS.com (Variant's Child) — Collection 284649
Mapping Type | Source Field (Shopify) | Destination Field (iPaaS.com) | Notes |
Field | FulfillmentService | FulFillment Service (custom) | |
Dynamic Formula |
| LocationId | Resolves the iPaaS.com Location id from the Shopify location id. |
Field | Available | QtyAvailable | Required. |
Lookup Translations
Shopify Product Status to iPaaS.com
Translates the Shopify product status to the iPaaS.com product status (for example active → Active, draft → Disabled). Confirm the values are configured for your store.
Error Handling
Missing required fields: the iPaaS.com Product requires Name and SKU; ensure they are present on the Shopify record.
Default options not filtered: the Option/Option Values filters exclude "Title" / "Default Title" — keep them in place to avoid importing placeholder options.
Unresolved location: inventory whose Shopify location does not map to an iPaaS.com Location is not recorded.
Testing & Validation
Product import: product appears in iPaaS.com with the correct title, SKU, and price.
Option exclusion: simple products with default "Title" options import without placeholder options.
Variant import: variants import with correct options and SKUs.
Inventory import: quantities reflect Shopify per location.
Overwrite check: confirm no externally-maintained iPaaS.com Product fields are blanked after an import (add preservation mappings if they are).
Additional Notes
Default Shopify placeholders ("Title", "Default Title") are always excluded by the Option and Option Values filters.
Ensure Lookup Translations for product status are configured before relying on imported status values.
Related Documents
iPaaS.com to Shopify Product Mapping Documentation — the FROM iPaaS.com direction (writing products to Shopify).
Add/Update Shopify Product TO iPaaS.com — mapping collection description and notes.
Add/Update Shopify Location TO iPaaS.com — locations must exist in iPaaS.com for inventory to attach.