Contents
Summary
ID Format
Deleted Record Support
Mapping Collection Status
Duplicate or Conflicting Mappings
Supported Child Collections
System Caveats
Setup Requirements
Integration Flow
Mappings
Error Handling
Testing & Validation
Out of Scope
Summary
Clover orders can be created and maintained from iPaaS.com Transaction records. When an iPaaS.com order qualifies for transfer, the integration builds or updates the matching Clover order, populating totals, tax and miscellaneous charge amounts, currency, pay type, order state, and reference identifiers, then attaches the order's lines and public notes through the supported child collections. Transfers run on demand through Manual Sync and automatically through the iPaaS.com Outbound Data Flows triggers for transactions.
ID Format
Manual Sync ID Format
When syncing a single order manually, enter the iPaaS.com Transaction record id (the numeric TransactionID), not the human-readable order number. For example, an order displayed as Order-001 with an iPaaS.com id of 10001 is entered as 10001.
External ID Format
After a transfer, the integration matches the resulting Clover order back to the iPaaS.com Transaction by a dedicated external reference, so a repeat transfer of the same record updates the same Clover order rather than creating a new one. The iPaaS.com transaction number is also written to the Clover order's ExternalReferenceId field, which supports visibility on the Clover order and acts as a fallback match key.
Deleted Record Support
Outbound delete is not supported for this flow. Deleting an iPaaS.com Transaction does not remove the corresponding order from Clover, and delete mappings are not included in the default templates. Deletions must be handled directly in Clover.
Mapping Collection Status
Status
The parent Transaction collections and their line and note child collections are Enabled.
Trigger Events
The transfer runs on Create and Update of a qualifying iPaaS.com Transaction record. It is triggered manually through Manual Sync, or automatically when the subscriber has enabled the iPaaS.com Outbound Data Flows triggers for transactions.
Duplicate or Conflicting Mappings
The Add and Update collections share the same Clover order scope: the Add path creates the Clover order and the Update path maintains it. Subscribers should ensure no other mapping targets the same Clover order record so that order data is not overwritten by a competing mapping.
Collision Handling
This integration does not offer configurable collision handling. Orders are matched to their iPaaS.com source by the dedicated external reference described in the ID Format section, and repeat transfers update the same order. There is no subscriber-selectable conflict-resolution method for this flow.
Unmapped Field Overwrite Risk
Each Update transfer rewrites the mapped values on the Clover order. Fields that are not mapped in these collections are left untouched, but every mapped field is overwritten with the current iPaaS.com value on each transfer. For any field that should not be overwritten from the iPaaS.com source, set a fixed destination value on that mapping rather than sourcing it from the iPaaS.com record.
Supported Child Collections
The parent Transaction collection drives two child collections, which add or maintain the order's detail after the parent order is written:
Transaction Line (Add Clover Transaction Line FROM iPaaS.com / Update Clover Transaction Line FROM iPaaS.com) — creates or maintains each Clover order line from an iPaaS.com transaction line.
Transaction Note (Add Clover Transaction Note FROM iPaaS.com / Update Clover Transaction Note FROM iPaaS.com) — creates or maintains each public order note from an iPaaS.com transaction note.
System Caveats
Clover Caveats
Clover expresses money amounts in cents and quantities in thousandths, so the integration converts amounts and quantities to those units when writing the order (see the Mappings section for each conversion). Clover does not accept prohibited transaction types — deposit and gift card orders — which is why those transactions are filtered out before transfer. The EmployeeId and OrderTypeId values must correspond to the merchant's existing Clover configuration to be accepted. When Clover reports that too many requests have been made in a short period, the integration automatically pauses and retries the affected calls; no subscriber action is required.
iPaaS.com Caveats
The transaction number must be unique so that each order maps to a single Clover order. The order total, tax amount, and miscellaneous charge amount must be numeric so the cents conversion succeeds; a non-numeric value causes a mapping error that appears in Integration Monitoring. Currency is set to USD for every order.
Integration-Specific Caveats
Prerequisite Handling. When the iPaaS.com order references a customer, the integration transfers a minimal customer (identified by email) to Clover first, automatically, as a prerequisite for the order. Subscribers do not need to pre-sync the customer. If the customer prerequisite fails, the order transfer is blocked and reported.
Order duplicate handling. At the time this documentation was written, transferring an order into Clover can, in some cases, produce a duplicate order for the same source reference rather than reconciling to the existing one. When this happens, the integration automatically removes the matching open duplicate, but it will not remove an order that has already progressed past the open state. If one or more non-open duplicates exist, the transfer stops and reports that manual intervention is required to resolve them. Subscribers should validate the create-and-repeat behavior in a staging environment before relying on it in production. See the Error Handling section and the Clover Integration Known Limitations article.
Setup Requirements
iPaaS.com Configuration
To transfer orders automatically, enable the iPaaS.com Outbound Data Flows triggers for transactions. Once enabled, qualifying transaction records created or updated in iPaaS.com are sent to Clover automatically without further subscriber action. Manual Sync is always available regardless of the Outbound Data Flows configuration.
Clover Configuration
The subscriber's Clover account must be connected and configured for the integration. The EmployeeId and OrderTypeId values used by the mapping must already exist in the merchant's Clover configuration. Refer to the Clover Installation Instructions article for the full connection walkthrough.
Integration Flow
A qualifying iPaaS.com Transaction is selected for transfer, either through Manual Sync or through an enabled Outbound Data Flows trigger.
The mapping filter is evaluated. Transactions whose number ends with -D (deposit) or -GC (gift card) are excluded and are not sent to Clover.
If the iPaaS.com order references a customer, the integration transfers a minimal customer (identified by email) to Clover first, automatically, as a prerequisite.
The parent Clover order is created (Add) or located and rewritten (Update) with its totals, currency, pay type, and reference identifiers. On the Add path the order is created in the open state.
Each iPaaS.com transaction line is attached as a Clover order line through the Transaction Line child collection.
Each qualifying public iPaaS.com transaction note is attached as a Clover order note through the Transaction Note child collection.
The Clover order is finalized once the full order hierarchy has been written. The order is matched back to the iPaaS.com Transaction by the dedicated external reference, so a repeat transfer updates the same order.
Mappings
The Add and Update parent collections use identical mappings except that the Add collection sets the initial order State to "open" and the Update collection omits that mapping (an existing order's state is not changed on update). The line and note child collections are identical between the Add and Update paths. Each pair is presented together below, with any differences noted.
Add / Update Clover Transaction FROM iPaaS.com
iPaaS.com data type: Transaction
Mapping Filter
!TransactionNumber.EndsWith("-D") && !TransactionNumber.EndsWith("-GC")Filter Description. A Transaction is transferred only when its TransactionNumber does not end with -D and does not end with -GC. Transactions whose number ends with -D (deposit) or -GC (gift card) are prohibited transaction types in Clover; they are intentionally excluded and are not sent. All other transactions pass the filter.
Description. Creates (Add) or maintains (Update) the parent Clover order, populating totals, tax and miscellaneous charge amounts, currency, pay type, and reference identifiers so the Clover order mirrors the iPaaS.com source.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Clover) | Description |
Dynamic Formula |
| EmployeeId | Recommended. Sends the employee identifier from the iPaaS.com order to the Clover order unchanged. Must match an employee that exists in the merchant's Clover configuration for the order to be accepted. If the source value is empty, no employee is sent. |
Dynamic Formula |
| OrderTypeId | Recommended. Sends the order type identifier unchanged. Must match an order type that exists in the merchant's Clover configuration for the order to be accepted. If the source value is empty, no order type is sent. |
Dynamic Formula |
| TaxAmount | Recommended. Rounds the iPaaS.com tax amount to two decimals and converts it to cents (×100), sent as a whole number — so a tax of 1.50 is sent as 150. An empty source is treated as 0. The source value must be numeric or the transfer reports a mapping error. |
Dynamic Formula |
| MiscChargeAmount | Recommended. Rounds the iPaaS.com shipping amount to two decimals and converts it to cents (×100), sent as a whole number — the iPaaS.com shipping amount becomes the Clover miscellaneous charge. An empty source is treated as 0. The source value must be numeric or the transfer reports a mapping error. |
Static |
| Currency | Fixed value supplied by the integration. Every order is transferred in US dollars; the subscriber does not set it. |
Dynamic Formula |
| Total | Recommended. Rounds the iPaaS.com order total to two decimals and converts it to cents (×100), sent as a whole number — so a total of 25.00 is sent as 2500. An empty source is treated as 0. The source value must be numeric or the transfer reports a mapping error. |
Field | TransactionNumber | ExternalReferenceId | Recommended. Copies the iPaaS.com transaction number into the Clover order's external reference so the order can be traced to its source and used as a fallback match key. The transaction number must be unique so each order maps to a single Clover order. |
Field | TransactionNumber | Title | Recommended. Copies the iPaaS.com transaction number into the Clover order title so the order is recognizable in Clover. If the transaction number is empty, the title is left empty. |
Static |
| State | Add only. Sets the new Clover order's state to open. Fixed value supplied by the integration. This mapping is present on the Add path only; the Update path does not change the order state. |
Static |
| GroupLineItems | Fixed value supplied by the integration. Tells Clover not to group identical line items, so each transferred line is kept as its own line. |
Static |
| PayType | Fixed value supplied by the integration; the subscriber does not set it. |
Field | EmailAddress | OrderEmailAddress | Recommended. Copies the iPaaS.com order email to the Clover order. If the source email is empty, the Clover order email is left empty. When the order references a customer, the integration also transfers a minimal customer identified by email first, automatically, as a prerequisite. |
Add / Update Clover Transaction Line FROM iPaaS.com
iPaaS.com data type: Transaction Line
Description. Creates (Add) or maintains (Update) each Clover order line from an iPaaS.com transaction line, converting price and quantity to the units Clover expects. This child collection has no mapping filter.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Clover) | Description |
Dynamic Formula |
| Name | Recommended. Uses the iPaaS.com line description as the Clover line name, shortened to a maximum of 127 characters to fit the Clover field limit; a longer description is cut off at 127 characters. If the description is empty, the line name is left empty. |
Dynamic Formula |
| Price | Recommended. Rounds the iPaaS.com line unit price to two decimals and converts it to cents (×100) — so a unit price of 4.99 is sent as 499. An empty source is treated as 0. The source value must be numeric or the transfer reports a mapping error. |
Dynamic Formula |
| UnitQty | Recommended. Rounds the iPaaS.com line quantity to three decimals and converts it to thousandths (×1000) — so a quantity of 2 is sent as 2000. An empty source is treated as 0. The source value must be numeric or the transfer reports a mapping error. |
Static |
| UnitName | Fixed value supplied by the integration for consistency across transferred lines. |
Field | Original SKU | ItemCode | Recommended. Uses the iPaaS.com line's Original SKU as the Clover line item code, linking the line to a Clover catalog item. When the item code does not match an existing Clover item, the line is written without a catalog link. Validate the handling of unmatched item codes in a staging environment before relying on it in production. |
Static |
| Printed | Fixed value supplied by the integration. Marks the line as not printed. |
Dynamic Formula |
| CreatedTime | Sets the line's created time from the parent transaction's created date and time, converted to the Unix timestamp format Clover expects, so every line on an order shares the order's creation time. Derived by the integration; no subscriber input needed. |
Dynamic Formula |
| OrderClientCreatedTime | Sets the line's client-side created time from the parent transaction's created date and time, converted to the Unix timestamp format Clover expects. Derived by the integration; no subscriber input needed. |
Static |
| Exchanged | Fixed value supplied by the integration. Marks the line as not exchanged. |
Static |
| Refunded | Fixed value supplied by the integration. Marks the line as not refunded. |
Static |
| IsRevenue | Fixed value supplied by the integration. Marks the line as counting toward revenue. |
Add / Update Clover Transaction Note FROM iPaaS.com
iPaaS.com data type: Transaction Note
Mapping Filter
IsPublic == true
Filter Description. A transaction note is transferred only when IsPublic is true. Public notes pass the filter and are written to the Clover order; private notes (where IsPublic is not true) are skipped and never sent to Clover.
Description. Creates (Add) or maintains (Update) each public order note on the Clover order from an iPaaS.com transaction note.
Mapping Type | Source Field (iPaaS.com) | Destination Field (Clover) | Description |
Field | Text | NoteText | Recommended. Copies the iPaaS.com note text to the Clover order note. Only public notes reach this mapping, so private notes are never sent. If the note text is empty, the Clover note is left empty. |
Error Handling
For the full catalog of Clover error messages and resolutions, see the Clover Error Messages article. The messages most relevant to this flow are:
"One or more unopened duplicate Order(s) exist for [external reference]. Manual intervention required." — While preparing to write an order for the given external reference, the integration found one or more existing Clover orders that share that reference and are not in an open state. The integration automatically removes matching open duplicates but will not remove orders that have progressed past open, so it stops rather than acting on completed or in-progress orders. Resolution: in Clover, locate the orders matching the external reference, review why more than one exists, remove or reconcile the unintended duplicate so only the correct order remains, then re-run the transfer. Review carefully before deleting any order; if unsure which is correct, contact iPaaS.com Support.
"ConvertToUnixTime requires input Parameter to be of type DateTime" — A timestamp conversion in the line mappings received a value that is not a date, usually because the parent transaction's created date/time is empty or invalid. Resolution: confirm the parent transaction supplies a valid created date/time, then re-run.
Clover API quota exceeded — Clover applied a rate limit during a burst of transfers. This is usually transient and the affected transfers are rescheduled automatically after the reported wait period. Resolution: no action is required for a one-off occurrence; if quota errors recur, stagger manual syncs and reduce how frequently large or overlapping syncs run. If the limit is consistently exceeded under normal operation, contact iPaaS.com Support.
Clover API error response — Clover rejected the order write. The message includes the detail Clover returned. Resolution: confirm the EmployeeId and OrderTypeId exist in the merchant's Clover configuration and that the order totals are numeric, then re-run.
A non-numeric Total, TaxAmount, or MiscChargeAmount on the source order causes the cents conversion to fail with a mapping error visible in Integration Monitoring; correct the source value and re-run.
Testing & Validation
Test Scenarios
Create an order. Create an iPaaS.com Transaction whose number does not end with -D or -GC and transfer it. Confirm a Clover order is created in the open state with the expected totals (in cents), currency USD, and the transaction number in the order title and external reference.
Update an order. Change a mapped value (for example, the total or tax amount) on an existing transferred order and re-transfer. Confirm the same Clover order is updated rather than a new order being created.
Excluded transaction types. Transfer a transaction whose number ends with -D or with -GC and confirm it is not sent to Clover.
ID format. Manually sync using the numeric iPaaS.com Transaction id (for example, 10001 for Order-001) and confirm the transfer succeeds.
Line items. Transfer an order with multiple lines and confirm each line appears in Clover with the correct name (truncated to 127 characters where applicable), price (in cents), and quantity (in thousandths).
Public vs private notes. Add both a public note and a private note to the source order, transfer, and confirm only the public note reaches Clover.
Customer prerequisite. Transfer an order that references a customer and confirm the minimal customer is created in Clover automatically before the order.
Duplicate handling. Transfer, then re-transfer, the same order and confirm the integration reconciles to the existing order. If a non-open duplicate condition is reported, confirm the manual-intervention message and resolve it in Clover.
Validation Checklist
The transaction number does not end with -D or -GC for any order expected to sync.
Total, TaxAmount, and MiscChargeAmount are numeric on the source order so the cents conversion succeeds.
EmployeeId and OrderTypeId match values that exist in the merchant's Clover configuration.
Line unit prices and quantities are numeric so the cents and thousandths conversions succeed.
Notes intended for Clover are marked public in iPaaS.com.
The order email address is valid where an order email is required.
Out of Scope
This documentation covers the Clover order and its line and note child collections. Customer address, payment, and product catalog data are handled by their own collections and are out of scope here. Outbound deletion of Clover orders is not supported.
