Status: Enabled (parent and all six children; the tracking child only acts when TrackingOnly is true)

Trigger Events: the iPaaS.com Transaction (Order) Create and Update outbound triggers (enabled per Setup Requirements below). The child collections have no independent trigger — they run as part of the parent order transfer.

Add/Update Shopify Order Lines FROM iPaaS.com (284676) — order line items, linked to Shopify products/variants by SKU.

Add/Update Shopify Order Tax Lines FROM iPaaS.com (284675) — tax amount, rate, and authority.

Add/Update Shopify Order Shipping Address FROM iPaaS.com (284673) — shipping-only address.

Add/Update Shopify Order Billing Address FROM iPaaS.com (284674) — billing-only address.

Add/Update Shopify Order Billing and Shipping Address FROM iPaaS.com (284678) — combined-address fallback.

Add Shopify Order Tracking-Only Fulfillment FROM iPaaS.com: one Shopify fulfillment per new tracking record; runs only when TrackingOnly is true.

One fulfillment per new tracking record. A tracking record whose tracking number is already on the Shopify order is skipped at the locations where it was fulfilled, whatever its quantities. A new shipment must arrive as a new tracking record with its own number.

Quantities are running totals. Each tracking record's iPaaSLineItemIdAndQty custom field lists {transactionId}|{lineId}-{quantity} entries, where the quantity is the total shipped so far for that order line. Only the amount not yet fulfilled in Shopify is fulfilled, up to what Shopify can still fulfill. For example, with a line ordered 5: tracking record T1 says 4 and fulfills 4; tracking record T2 says 5 and fulfills the remaining 1.

Lines are matched by their order-line link. The template's LineItems formula turns each iPaaSLineItemIdAndQty entry into the linked Shopify order line; an entry whose line is not linked to the Shopify order is skipped. A custom LineItems formula can supply a SKU instead: the line is then matched on SKU, trying the unit-suffixed SKU first when the formula also supplies TrackingLineItem_SellingUnit for products sold in alternate units of measure. A SKU that matches more than one line on the order is skipped.

One fulfillment per location. When a shipment covers lines assigned to different Shopify locations, one fulfillment is created per location, each with the same tracking number. If one of them fails, a re-sync creates the missing location's fulfillment.

Fulfillments from the separate tracking event count. Fulfillments added by Add Shopify Fulfillment FROM iPaaS.com are recognized: their tracking numbers are skipped and their quantities count toward the running totals.

Fully fulfilled orders. Once every item is fulfilled, a new tracking record has nothing left to fulfill; the transfer completes without an error.

No echo. The integration ignores the order-update notification Shopify sends for each fulfillment it creates, so adding tracking does not import the order back into iPaaS.com as a change. A transfer that creates nothing ignores nothing.

Order edits are not sent. For a linked order, changes made in iPaaS.com (for example notes, addresses, or metafields) are not written to Shopify. Turn it on only when Shopify does not need order edits after the order is created.

An order is never created. If the linked order is not found in Shopify, the transfer fails and no order is created.

Tracking records without line items are skipped. A tracking record without iPaaSLineItemIdAndQty (for example one added by another system) is skipped by the collection filter: it creates nothing and records no error.

Create only. Existing fulfillments are never updated or cancelled; a changed tracking number or quantity on an existing tracking record is not sent to Shopify.

A line item is mandatory. Shopify will not create an order without at least one line item; the parent filter enforces this.

Shipping lines set the delivery method and are immutable. Shopify decides an order's delivery method solely from the presence of a shipping line at creation. Map ShippingLine_Title and ShippingLine_Price or Shopify marks the order "Shipping not required" even when a shipping address exists. Shipping lines cannot be changed after the order is created.

Financial status is a case-sensitive enum. Only authorized, paid, partially_paid, pending, partially_refunded, refunded, and voided are accepted; the template maps the iPaaS.com Status to these values with a formula.

Region / country values are not validated on order addresses. Invalid values are accepted silently and stored.

External-id link required. The Shopify order id is saved as the external id so subsequent updates edit the same Shopify order rather than creating a duplicate.

Duplicate detection depends on the metafield preset. Without the transaction-number metafield created in Shopify and configured in the matching preset, an unlinked transaction cannot be matched to an existing Shopify order and a re-sync can create a duplicate.

Customer link is not auto-created. The order's customer is resolved from the existing iPaaS.com-to-Shopify customer link; if the customer is not yet linked, the order is created without that customer association.

SHOPIFY METAFIELD FOR TRANSACTION NUMBER MATCHING: set to the namespace.key of the Shopify order metafield used for duplicate-order detection.

Create Line Item Product as Prerequisite — when enabled, missing line-item products are created in Shopify automatically before the order is written.

No line items: transactions without lines are filtered out — an order cannot be created in Shopify.

Wrong type: transactions whose type is not Order are filtered out.

Failed prerequisite product: when line-item product creation is enabled and a product transfer fails, the whole order transfer fails.

Unresolvable SKU: by default an order line whose SKU — with its selling unit, when present — does not match a Shopify variant is skipped; relax the line filter to allow free-form items.

Invalid financial status: an unrecognized source status maps to null financial status.

Tracking-only order not found: the linked Shopify order no longer exists, so tracking cannot be added and no order is created (SHPY-EXTN-1051).

Tracking-only without an order id: a tracking-only transfer has no valid Shopify order id (SHPY-VALD-1028).

Tracking-only on a return: TrackingOnly cannot be combined with Type = return (SHPY-VALD-1027).

Fulfillment orders unavailable: the connection lacks the fulfillment order scopes (SHPY-EXTN-1052).

Some tracking failed: one or more fulfillments could not be created; the others were created and a re-sync creates only the missing ones (SHPY-EXTN-1053).

Create a new Transaction of type Order with at least one line and sync it; verify a new Shopify order is created and the Shopify order id is saved as the external id.

Re-sync a transaction that already exists in Shopify (matched by the transaction-number metafield) and confirm it updates the existing order instead of creating a duplicate.

Sync an order with a line whose SKU is not yet in Shopify, with Create Line Item Product as Prerequisite enabled, and confirm the product is created first and the order succeeds.

Sync an order with a shipping-only, a billing-only, and a combined address and confirm each routes to the correct slot(s).

Confirm the order carries a delivery method because the shipping line title and price are mapped.

With tracking-only updates turned on: add a tracking record covering part of a linked order and update the transaction; confirm one fulfillment with that tracking number and quantity, and that an order note changed in iPaaS.com did not reach Shopify.

Re-send the same tracking number with a higher quantity and confirm nothing is added; add a new tracking record with the full running total and confirm only the remainder is fulfilled.

Create a new order with tracking-only updates turned on and confirm it is still created normally.

New orders appear in Shopify with correct totals, financial status, and currency.

The Shopify order id is saved as the external id after the first successful sync.

Duplicate-order matching links to the existing order via the metafield.

Line items link to the correct products/variants by SKU.

Tax lines and addresses appear correctly on the order.

A delivery method is present on the order.

The default template includes two placeholder values that must be reviewed before production use: the static global.Order-Desc value (test desc from mappings) and the static USD currency.

Customers are not auto-created in this direction. Establish the iPaaS.com-to-Shopify customer link beforehand if the order should carry a customer.

iPaaS.com <> Shopify: Background

Shopify Installation Instructions

Shopify Connections and Settings

Shopify Mapping Functions

Shopify API Endpoints

Shopify Error Messages

Shopify Known Limitations

Shopify to iPaaS.com Deposit Ticket Mapping Documentation

iPaaS.com to Shopify Fulfillment Mapping Documentation

iPaaS.com to Shopify Order Return Mapping Documentation

Shopify to iPaaS.com Order Return Mapping Documentation

Shopify to iPaaS.com Order Mapping Documentation