NetSuite Gift Certificate To iPaaS.com Mapping Documentation

A NetSuite gift certificate can be captured into iPaaS.com as a gift card. The integration records the gift-certificate code, balance, status, purchase and expiration dates, original amount, and the receiving customer's name and email. A single Add collection creates the gift card on first capture and an Update collection keeps the balance and status current.

ID Format

Manual Sync ID Format

Enter the NetSuite gift certificate's internal ID on the Manual Sync page.

External ID Format

iPaaS.com records the NetSuite gift certificate's internal ID as the external-ID link, and the gift-certificate code (Number) is the business key used to match an existing gift card, so later transfers update the existing card rather than creating a duplicate.

Deleted Record Support

There is no Gift Certificate delete collection — deleting or deactivating a gift certificate in NetSuite does not remove the iPaaS.com gift card. A fully redeemed certificate is captured with status Redeemed rather than deleted.

Mapping Collection Status

Status: Enabled. Two collections — Add (initial capture) and Update (balance/status refresh).
Trigger Events: Create and Update. Gift certificates are captured on demand from the Manual Sync page and on the gift-certificate events enabled in Inbound Data Flows (see NetSuite Connections and Settings).

Duplicate or Conflicting Mappings

The Add and Update collections capture the same gift certificate; the Add collection only admits certificates with a remaining balance (see the Add filter). The gift-card code (Number) is the matching key — changing or un-mapping it after gift cards exist will break matching and can create duplicates, so keep it stable once live.

Supported Child Collections

None. The gift certificate is captured as a single record.

System Caveats

NetSuite Caveats

Gift certificates are matched by code. The Number (gift-certificate code) is the business key; it is required.
Balance and status come from NetSuite. The remaining amount drives both the iPaaS.com balance and the derived status (Redeemed when the remaining amount is zero or less, otherwise Active).

iPaaS.com Caveats

Gift card data type. These collections populate the iPaaS.com Gift Card entity.

Setup Requirements

Inbound Data Flows + webhook scripts — enable the NetSuite gift-certificate events and install the webhook scripts for automatic capture; otherwise use Manual Sync.

Authentication

The integration authenticates to NetSuite using the connection configured for the integration; the webhook scripts that emit NetSuite events are documented in NetSuite Connections and Settings.

Integration Flow

A NetSuite gift certificate is captured — on demand (internal ID) or on gift-certificate events when Inbound Data Flows and the webhook scripts are in place.
The Add collection admits only certificates with a remaining balance greater than zero; the Update collection refreshes an existing gift card regardless of balance.
The integration creates or updates the iPaaS.com gift card with the code, balance, status, dates, original amount, and the receiving customer's name and email.

Mappings

The Add and Update collections share the same field mappings; only the Add collection carries a filter.

Add / Update NetSuite Gift Certificate TO iPaaS.com

iPaaS.com data type: Gift Card

Mapping Filter (Add collection only)

AmountRemaining > 0

Filter Description. The Add collection captures a gift certificate only when its remaining balance is greater than zero (a fully redeemed certificate is not newly created). The Update collection has no filter and refreshes an existing gift card regardless of balance.

Mapping Type	Source Field (NetSuite)	Destination Field (iPaaS.com)	Description
Field	GiftCertCode	Number	Required. The gift-certificate code — the gift card's business key and matching key.
Static	`"Gift Card"`	Type	Control. The iPaaS.com gift-card type.
Field	AmountRemaining	Balance	Recommended. The remaining balance on the gift certificate.
Dynamic Formula	`if(AmountRemaining <= 0) return "Redeemed"; return "Active";`	Status	Recommended. `Redeemed` when the remaining balance is zero or less, otherwise `Active`.
Field	Message	Description	Optional. The gift-certificate message.
Field	OriginalAmount	OriginalAmount	Optional. The original face value of the gift certificate.
Field	CreatedDate	PurchaseDate	Optional. The date the gift certificate was created.
Field	ExpirationDate	ExpirationDate	Optional. The gift certificate's expiration date.
Field	Name	ReceivingCustomer	Optional. The receiving customer's name.
Field	Email	ReceivingCustomerEmail	Optional. The receiving customer's email address.
Dynamic Formula	`SpaceportSystemId`	Originating_SystemId	Control. The originating iPaaS.com system id, recorded for traceability.

Error Handling

Gift certificate skipped (zero balance on Add) — a fully redeemed certificate is not created by the Add collection. Resolution: none required; the Update collection maintains existing cards.

Testing & Validation

Test Scenarios

Capture a new gift certificate. Manually sync a NetSuite gift certificate with a positive balance and confirm an iPaaS.com gift card with the code, balance, status Active, and dates.
Redeem to zero. Reduce the balance to zero in NetSuite and confirm the Update collection sets status Redeemed.
Matching. Re-sync the same certificate and confirm the existing gift card is updated (matched by code), not duplicated.

Validation Checklist

The gift-certificate code mapping (Number) is left stable once gift cards exist.
Inbound Data Flows and the NetSuite webhook scripts are in place for automatic capture.

Additional Notes

Known limitations affecting gift certificates on transactions are covered under Sales Order and Cash Sale in NetSuite Known Limitations.