Shopify to iPaaS.com Deposit Ticket Mapping Documentation

A deposit ticket is a secondary transaction that the integration derives from a Shopify order to satisfy Counterpoint-style accounting requirements. When a qualifying Shopify order is transferred to iPaaS.com, the integration clones the order, appends a -D suffix to its transaction number, and re-runs the transfer; the deposit-ticket collections are filtered to capture only that derived, suffixed transaction. The deposit ticket records the non-gift-card (product) portion of the order — its header, address, line items, and payments — into iPaaS.com.

This document covers the standard (non-Plus) deposit-ticket tree. Shopify Plus stores use the parallel Add Shopify Plus Deposit Ticket TO iPaaS.com tree, which additionally splits gift-card value into a separate gift card ticket.

ID Format

Deposit tickets use the Shopify order number with a -D suffix as the transaction number in iPaaS.com. The ticket's parent transaction is resolved from the Shopify transaction id with the -D suffix removed.

Deleted Record Support

Deposit tickets are derived from orders; they are not independently deleted through these collections. Order deletion handling follows the order transfer, not the deposit-ticket tree.

Mapping Collection Status

Status: Enabled (standard tree). Disable this tree if you are using Shopify Plus and use the Plus deposit-ticket tree instead.
Trigger: Shopify Order Created (orders/create) and Order Updated (orders/updated) events. There is no Shopify "deposit ticket" event; the ticket is derived as a follow-on action of the order transfer. No automatic transfers occur until the order inbound subscriptions are enabled.

Duplicate or Conflicting Mappings

The Shopify Plus counterpart is Add Shopify Plus Deposit Ticket TO iPaaS.com (disabled by default). Run the standard tree on non-Plus stores and the Plus tree on Shopify Plus stores — never both. The stored collection note reads: "Disable this mapping collection if you are using Shopify PLUS."

Supported Child Collections

Parent: Add Shopify Deposit Ticket TO iPaaS.com (284590).

Add Shopify Deposit Ticket Address TO iPaaS.com (284614)
Add Shopify Deposit Ticket Line TO iPaaS.com (284615)
Add Shopify Deposit Ticket Payment Gift Card TO iPaaS.com (284616)
Add Shopify Deposit Ticket Payment TO iPaaS.com (284617)

System Caveats

iPaaS.com Caveats

The header requires the originating SystemId and a resolvable ParentId; because the ticket is derived during the order transfer, the parent transaction is present when the ParentId lookup runs.
For a -D deposit ticket the integration performs no prerequisite work — the customer and any gift cards were transferred as prerequisites during the original order transfer.

Shopify Caveats

Deposit tickets are recognized solely by the -D order-number suffix, not by any Shopify setting.
Shopify has no deposit-ticket webhook; the Shopify connection must include the order read scopes used by the order transfer.

Setup Requirements

iPaaS.com Configuration

Enable the Add Shopify Deposit Ticket TO iPaaS.com parent and its four child collections.
Configure the Shopify Transaction Status To iPaaS.com and Shopify Transaction Line Status To iPaaS.com lookup translations.
Review the address child's ShippingMethod formula and replace the placeholder carrier mapping with your real carrier codes and iPaaS.com shipment-method names.

Shopify Configuration

Authorize the Shopify connection with the order read scopes (and the related read scopes the order transfer uses, such as read_orders).

Integration Flow

A Shopify order is transferred to iPaaS.com.
If the order requires a deposit ticket, the integration clones it, appends -D, and re-runs the transfer.
The deposit-ticket header is recorded (SystemId, TransactionNumber, ParentId, totals, status, email).
Address, line items, and payments are processed through the child collections.
iPaaS.com records a structured deposit ticket for downstream accounting and integration.

Mappings

Add Shopify Deposit Ticket TO iPaaS.com — Parent (284590)

Filter: OrderNumber.EndsWith("-D")

Mapping Type	Source (Shopify)	Destination (iPaaS.com)	Requirement / Note
Dynamic Formula	`SpaceportSystemId`	SystemId	Required.
Field	OrderNumber	TransactionNumber	Required.
Dynamic Formula	`GetSpaceportId(Id.Substring(0, Id.Length - 2), "Transaction", SpaceportSystemId)`	ParentId	Required. Resolves the parent transaction's iPaaS.com id from the Shopify id with `-D` removed.
Static	Ticket	Type	Required.
Lookup Translation	Shopify Transaction Status	Status	Recommended.
Dynamic Formula	`if(Email == null \\|\\| Email == "") return "defaultCustomer@shopify.com"; return Email;`	EmailAddress	Recommended. Falls back to a default email when blank — replace the default with your own catch-all if needed.
Field	TotalDiscounts	DiscountAmount
Field	TotalTax	TaxAmount
Field	ShippingPrice	ShippingAmount
Field	SubtotalPrice	Subtotal
Field	TotalPrice	Total
Field	ItemsTotal	TotalQty

Add Shopify Deposit Ticket Address TO iPaaS.com — Child (284614)

No filter (all addresses).

Mapping Type	Source (Shopify)	Destination (iPaaS.com)	Note
Dynamic Formula	`IsBillingAddress == "TRUE"`	IsPrimaryBilling
Dynamic Formula	`IsShippingAddress == "TRUE"`	IsPrimaryShipping
Field	Address1	Address1
Field	Address2	Address2
Field	City	City
Field	ProvinceCode	Region
Field	Country	Country
Field	Zip	PostalCode
Dynamic Formula	carrier translation from `Parent.ShippingLines[0].Code`	ShippingMethod	Template maps `Standard` → `UPS GROUND` plus an example branch — replace with your real carriers.
Field	FirstName	FirstName
Field	LastName	LastName
Field	Company	Company

Add Shopify Deposit Ticket Line TO iPaaS.com — Child (284615)

No filter (all lines; gift-card lines mapped to SKU SHOPIFY-GC). The Shopify Plus line child instead uses a GiftCard == false filter.

Mapping Type	Source (Shopify)	Destination (iPaaS.com)	Note
Static	Product	Type
Lookup Translation	Shopify Transaction Line Status	Status
Dynamic Formula	`if(GiftCard){return "SHOPIFY-GC";} else {return Sku;}`	Sku	Gift-card lines get the static SKU `SHOPIFY-GC`.
Field	Title	Description
Field	Quantity	Qty
Dynamic Formula	`((ConvertToDecimal(Price) * Quantity) - SumFieldFromCollection(DiscountAllocations, "Amount")) / Quantity`	UnitPrice	Net per-unit price after discounts.
Dynamic Formula	`(ConvertToDecimal(Price) * Quantity) - SumFieldFromCollection(DiscountAllocations, "Amount")`	ExtendedPrice	Net line total after discounts.
Field	Price	OriginalUnitPrice
Dynamic Formula	`SumFieldFromCollection(DiscountAllocations, "Amount")`	DiscountAmount
Dynamic Formula	`SumFieldFromCollection(TaxLines, "Rate")`	TaxPercent
Dynamic Formula	`SumFieldFromCollection(TaxLines, "Price")`	EstimatedTaxAmount

Add Shopify Deposit Ticket Payment Gift Card TO iPaaS.com — Child (284616)

Filter: Gateway == "gift_card"

Mapping Type	Source (Shopify)	Destination (iPaaS.com)
Dynamic Formula	`Gateway`	Method
Static	Shopify Gift Certificate	Description
Field	Amount	Amount
Static	Captured	Status

Add Shopify Deposit Ticket Payment TO iPaaS.com — Child (284617)

Filter (non-gift-card, successful authorization or sale):

if (Kind == "authorization" && CreditCardAuthIsCaptured(Authorization, Parent.Transactions) == false && Status == "success" && Gateway !="gift_card") {return true;}
else if (Kind == "authorization" && CreditCardAuthIsCaptured(Authorization, Parent.Transactions) == true && Status == "success" && Gateway !="gift_card") {return true;}
else if (Kind == "sale" && Status == "success" && Gateway !="gift_card") {return true;}
else {return false;}

Mapping Type	Source (Shopify)	Destination (iPaaS.com)	Note
Dynamic Formula	`Gateway`	Method	Includes an optional, commented-out payment-method-name search.
Field	Message	Description
Field	Amount	Amount
Dynamic Formula	Authorized vs Captured by transaction kind and capture state	Status

Lookup Translations

Shopify Transaction Status To iPaaS.com

Source value (Shopify)	Destination value (iPaaS.com)
PENDING	Pending
FULFILLED	Complete
VOIDED	Cancelled
SHIPPED	Shipped
CONFIRMED	Pending
PAID	Pending
REFUNDED	Cancelled
true	Pending

Shopify Transaction Line Status To iPaaS.com

Source value (Shopify)	Destination value (iPaaS.com)
PARTIAL	Pending
FULFILLED	Complete
NOT ELIGIBLE	Cancelled
true	Pending

Error Handling

Order number without -D: skipped from deposit-ticket mapping (handled as a normal order).
Missing parent transaction: the ParentId lookup cannot link the ticket; this ordering is handled automatically by the order cascade.
Authorization not captured: recorded with status Authorized rather than Captured.

Testing & Validation

Deposit ticket creation: a qualifying order produces a -D ticket with correct header totals and status.
Gift-card vs non-gift-card split: gift-card-gateway payments land in the gift-card payment child; other payments land in the standard payment child.
Line pricing: unit and extended prices are net of discounts.
Validation checklist: transaction number carries -D; header, address, line, and payment mappings are correct; totals match the Shopify order.

Additional Notes

Validate the dynamic formulas (especially the ShippingMethod carrier translation) before relying on the ticket in production.
The standard tree maps gift-card lines on the deposit ticket itself; Shopify Plus stores split gift cards into a separate gift card ticket.