Summary
Invoices that iPaaS.com created in BigCommerce B2B Edition come back into iPaaS.com, with their payments. The supported flow is a round trip: an iPaaS.com Invoice Transaction (typically created by your ERP once an order ships) creates the invoice in B2B Edition, and later changes to that invoice — its due date, open balance, status, and the payments applied to it — are captured back onto the same Invoice Transaction, with payments recorded as Transaction Payments. Invoices created directly in B2B Edition are not imported. Because BigCommerce B2B Edition does not emit invoice webhooks, invoices are captured through scheduled polling, or on demand from the iPaaS.com Manual Sync page.
This article is the field-level companion to BigCommerce B2B Edition Support. B2B handling is off by default and only applies when B2B support is enabled on the subscription. Creating invoices in BigCommerce from iPaaS.com is covered by the companion iPaaS.com to BigCommerce B2B Invoice Mapping Documentation.
Contents
Data Types and Direction
ID Format
Deleted Record Support
Custom Field Support
Mapping Collection Status
Duplicate or Conflicting Mappings
Collision Handling
Supported Child Collections
System Caveats
Setup Requirements
Integration Flow
Mappings
Testing and Validation
Additional Notes
Data Types and Direction
This article documents the following mapping collections and the iPaaS.com data type each one operates on. Every collection here transfers BigCommerce to iPaaS.com.
Collection | iPaaS.com data type | Direction |
Update BigCommerce B2B Invoice TO iPaaS.com | Transaction | BigCommerce to iPaaS.com |
Update BigCommerce B2B Invoice Payment TO iPaaS.com (child) | Transaction Payment | BigCommerce to iPaaS.com |
The invoice updates the Invoice Transaction that created it, which is linked to its originating order as a child (ParentId). It never creates a Transaction. The payment collection is a child of the invoice collection.
Supported Flow
Supported: invoices created from iPaaS.com through Add BigCommerce B2B Invoice FROM iPaaS.com. Later changes to those invoices come back onto the same Invoice Transaction.
Not supported: invoices created directly in BigCommerce B2B Edition. They have no Invoice Transaction in iPaaS.com, so they are not imported, and the order collections skip them because they carry an invoice number.
ID Format
Manual Sync ID Format
Invoice: enter the B2B Edition invoice ID followed by _INVOICE (for example, 13521046_INVOICE). The invoice ID is the number B2B Edition shows for the invoice.
Invoice payments have no independent Manual Sync entry point; they transfer as part of the parent invoice.
External ID Format
The Invoice Transaction's external ID is {invoice ID}_INVOICE. It is saved when Add BigCommerce B2B Invoice FROM iPaaS.com creates the invoice, and the inbound invoice collection uses it to find the Invoice Transaction. Each payment's BigCommerce identifier is recorded on its Transaction Payment, so payments are matched and updated in place on later transfers.
Deleted Record Support
Inbound delete is not supported for these collections. Removing an invoice or payment in BigCommerce does not remove the corresponding record in iPaaS.com.
Custom Field Support
The invoice-specific values (external ID, due date, open balance) and the invoice-payment reference values are carried on iPaaS.com custom fields on the Transaction and Transaction Payment. These custom fields are part of the default configuration and require no manual creation.
Mapping Collection Status
Both collections ship Enabled. BigCommerce B2B Edition does not send invoice webhooks, so invoices transfer through a scheduled poll event configured under Inbound Data Flows; the payment child transfers as part of the invoice. The invoice collection processes only records that carry an invoice number, and the payment collection processes only completed payments whose payment method already exists in iPaaS.com (see the Mappings section). Automatic transfers do not run until the poll event is configured — see Setup Requirements.
Duplicate or Conflicting Mappings
The invoice poll returns invoices as order-type records, so Add BigCommerce Order TO iPaaS.com and Update BigCommerce Order TO iPaaS.com must skip records that carry an invoice number; their filters include that condition. Only the invoice collection then applies to an invoice. It runs as an Update and keeps the Invoice Transaction's existing header values, so it never creates a competing record.
Collision Handling
The invoice is matched to its Invoice Transaction through the {invoice ID}_INVOICE external ID. An invoice without that link (one created directly in B2B Edition) is skipped. Each payment is matched by its BigCommerce payment identifier so it is recorded once and updated in place.
Supported Child Collections
Update BigCommerce B2B Invoice TO iPaaS.com → Update BigCommerce B2B Invoice Payment TO iPaaS.com
The payment collection is a child of the invoice collection and transfers as part of the invoice.
System Caveats
BigCommerce Caveats
B2B Edition required. Invoices exist only when the store runs BigCommerce B2B Edition and B2B support is enabled on the subscription.
No invoice webhooks. BigCommerce B2B Edition does not emit invoice change events, so invoices are captured by scheduled polling rather than in real time.
Payment method must exist in iPaaS.com first. An invoice payment cannot transfer unless its resolved payment method already exists in iPaaS.com — run the Initialize Data feature for Payment Methods before enabling the payment collection.
One invoice per order. B2B Edition generates one invoice from an order; a second invoice for the same order is refused.
Rate limiting. When BigCommerce rate-limits requests, the transfer is automatically rescheduled to resume after the limit window resets — no subscriber action is required.
iPaaS.com Caveats
Invoices created from iPaaS.com only. Only invoices created by Add BigCommerce B2B Invoice FROM iPaaS.com come back. Invoices created directly in B2B Edition are not imported.
Originating order in iPaaS.com. The Invoice Transaction's parent link resolves from the invoice's order number, so the order should already be in iPaaS.com.
Status translation. A paid invoice sets the Transaction status to Complete; any other invoice state sets it to Awaiting Payment. A completed payment resolves to Approved, a failed payment to Failed, and any other state to Pending. Review these values against your workflow.
Setup Requirements
Automatic transfers do not run until the invoice poll event is configured. Under Inbound Data Flows in the subscription configuration, add a poll event for B2B invoices, and confirm B2B Edition is enabled. Create invoices through Add BigCommerce B2B Invoice FROM iPaaS.com (see the companion iPaaS.com to BigCommerce article). Before enabling the payment collection, run the Initialize Data feature for Payment Methods so the methods referenced by invoice payments exist in iPaaS.com. See BigCommerce B2B Edition Support for the poll-event setup (scope store/order/poll, filters B2B_Invoice and B2B_Invoice_Payment).
Integration Flow
Invoice and its payments:
An iPaaS.com Invoice Transaction creates the invoice in B2B Edition through Add BigCommerce B2B Invoice FROM iPaaS.com, and {invoice ID}_INVOICE is saved as its external ID.
A B2B invoice poll event fires, or the invoice is manually synced by {invoice ID}_INVOICE.
The invoice is matched to its Invoice Transaction through that external ID. An invoice without the link is skipped.
The invoice's due date, open balance, external reference, and status are recorded on the Invoice Transaction, its parent link is set to the originating order, and the Invoice Transaction's other header values are kept.
Each payment applied to the invoice is captured as a Transaction Payment on the Invoice Transaction — its payment method is resolved against iPaaS.com's payment methods, and only completed payments are recorded.
Mappings
Each collection below lists its Mapping Filter, the iPaaS.com data type it operates on, and its field mapping table. The Description column carries the required/recommended classification and behavior for each field.
Update BigCommerce B2B Invoice TO iPaaS.com
iPaaS.com data type: Transaction
Captures a BigCommerce B2B invoice onto the Invoice Transaction that created it. It runs as an Update: the identity and financial header fields keep the Invoice Transaction's values, while the invoice-specific fields (external reference, due date, open balance), the parent-order link, the type, and the status are set from the invoice.
Mapping Filter: processes a record only when the invoice number is present — that is, when the incoming record is an invoice rather than a plain order.
Mapping Type | Source Field (BigCommerce) | Destination Field (iPaaS.com) | Description |
Field | invoice Invoice_ExternalId | BC B2B Invoice External ID | Optional. The external reference B2B Edition holds for the invoice (for example, an ERP invoice number); empty when none is set. Matching uses the Transaction's external ID, not this field. |
Field | invoice Invoice_DueDate | BC B2B Invoice Due Date | Recommended. The invoice due date. |
Field | invoice Invoice_OpenBalance_Value | BC B2B Invoice Open Balance Value | Recommended. The invoice's outstanding balance. |
Dynamic Formula | DestinationValue (preserve) | SystemId | Recommended. Keeps the Invoice Transaction's existing source system. |
Dynamic Formula | DestinationValue (preserve) | TransactionNumber | Recommended. Keeps the Invoice Transaction's existing number (for example, your ERP's invoice number). |
Dynamic Formula | resolves parent order from Invoice_OrderNumber | ParentId | Recommended. Links the Invoice Transaction to its originating order Transaction. The order must already exist in iPaaS.com. |
Dynamic Formula | DestinationValue (preserve) | CustomerId | Recommended. Keeps the buyer already recorded on the Invoice Transaction. |
Static |
| Type | Required. Fixed value identifying the record as an invoice. |
Dynamic Formula | derived from Invoice_Status | Status | Recommended. A paid invoice resolves to Complete; any other state to Awaiting Payment. |
Dynamic Formula | DestinationValue (preserve) | EmailAddress | Recommended. Keeps the Invoice Transaction's email address. |
Dynamic Formula | DestinationValue (preserve) | DiscountAmount | Recommended. Keeps the Invoice Transaction's discount amount. |
Dynamic Formula | DestinationValue (preserve) | TaxAmount | Recommended. Keeps the Invoice Transaction's tax amount. |
Dynamic Formula | DestinationValue (preserve) | ShippingAmount | Recommended. Keeps the Invoice Transaction's shipping amount. |
Dynamic Formula | DestinationValue (preserve) | Subtotal | Recommended. Keeps the Invoice Transaction's subtotal. |
Dynamic Formula | DestinationValue (preserve) | Total | Recommended. Keeps the Invoice Transaction's grand total. |
Dynamic Formula | DestinationValue (preserve) | TotalQty | Recommended. Keeps the Invoice Transaction's total item quantity. |
Dynamic Formula | DestinationValue (preserve) | TransactionCreatedDateTime | Recommended. Keeps the Invoice Transaction's original creation date and time. |
Update BigCommerce B2B Invoice Payment TO iPaaS.com
iPaaS.com data type: Transaction Payment
Captures the payments applied to a BigCommerce B2B invoice as Transaction Payments on the Invoice Transaction. This is a child of the invoice collection, so it applies only to invoices created from iPaaS.com.
Mapping Filter: resolves the payment method (the payment gateway when present, otherwise the payer name), searches for a matching payment method in iPaaS.com, and processes the payment only if the method exists and the payment is in a completed processing state. When no matching payment method exists, the transfer stops and asks you to run the Initialize Data feature for Payment Methods so the method exists beforehand.
Mapping Type | Source Field (BigCommerce) | Destination Field (iPaaS.com) | Description |
Field | payment Payment_PayerName | BC B2B Invoice Payment Payer Name | Recommended. The name of the party who made the payment. |
Field | payment Payment_CustomerName | BC B2B Invoice Payment Customer Name | Recommended. The customer name associated with the payment. |
Field | payment Payment_CustomerId | BC B2B Invoice Payment Customer ID | Recommended. The BigCommerce customer identifier associated with the payment. |
Dynamic Formula | payment line item InvoiceNumber | BC B2B Invoice Payment Invoice Number | Recommended. The invoice number the payment applies to. |
Field | payment Payment_ExternalCustomerId | BC B2B Invoice Payment External Customer ID | Recommended. The external customer identifier, for reconciliation. |
Field | payment Payment_ExternalId | BC B2B Invoice Payment External ID | Recommended. The payment's external identifier, used to match the payment on later transfers. |
Field | payment Payment_AppliedStatus | BC B2B Invoice Payment Applied Status | Recommended. Whether and how the payment has been applied to the invoice. |
Dynamic Formula | payment total Code | BC B2B Invoice Payment Total Code | Recommended. The currency code of the payment amount. |
Field | payment Payment_ChannelId | BC B2B Invoice Payment Channel ID | Recommended. The BigCommerce channel the payment was taken through. |
Dynamic Formula | BigCommerce payment identifier | BC B2B Invoice Payment ID | Recommended. The BigCommerce payment identifier, used to match the payment on later transfers. |
Field | payment Payment_ChannelName | BC B2B Invoice Payment Channel Name | Recommended. The name of the channel the payment was taken through. |
Dynamic Formula | payment line item InvoiceId | BC B2B Invoice Payment Invoice ID | Recommended. The identifier of the invoice the payment applies to. |
Field | payment Payment_StoreHash | BC Store Hash | Recommended. The BigCommerce store hash the payment originated from. |
Dynamic Formula | payment module transaction type | MethodInfo | Recommended. Additional method detail — the transaction type from the payment's most recent gateway transaction. |
Dynamic Formula | resolves the iPaaS.com payment method | Method | Recommended. The iPaaS.com payment method, resolved from the gateway or payer name. The method must already exist in iPaaS.com (run Initialize Data for Payment Methods). |
Dynamic Formula | payment Memo | Description | Recommended. The payment memo. |
Dynamic Formula | payment total Value | Amount | Recommended. The payment amount. |
Dynamic Formula | derived from payment processing status | Status | Recommended. A completed payment resolves to Approved, a failed payment to Failed, and any other state to Pending. |
Testing and Validation
Test Scenarios
Round trip. Send an Invoice Transaction (parent: an order that came from BigCommerce) through Add BigCommerce B2B Invoice FROM iPaaS.com, then poll (or manually sync {invoice ID}_INVOICE) and verify the same Invoice Transaction gets the due date, open balance, and status, keeps its type Invoice and number, and its parent is the order.
Invoice created in B2B Edition. Create an invoice directly in B2B Edition, poll it, and confirm it is skipped: no Transaction is created or updated and no error is logged.
Status translation. Confirm a paid invoice sets the Transaction status to Complete and an unpaid one to Awaiting Payment.
Payment capture. Confirm a completed payment is recorded as a Transaction Payment with the mapped payer, amount, method, and status; confirm a payment whose method does not exist in iPaaS.com stops with the Initialize-Data message.
Payment status. Confirm completed / failed / other payments resolve to Approved / Failed / Pending.
Validation Checklist
B2B Edition is enabled and the invoice poll event is configured before expecting automatic transfers.
Payment methods referenced by invoice payments exist in iPaaS.com (run Initialize Data for Payment Methods).
Invoice and payment status translations map to the values your workflow expects.
Invoices are created through Add BigCommerce B2B Invoice FROM iPaaS.com, and the originating orders are in iPaaS.com.
Add BigCommerce Order TO iPaaS.com and Update BigCommerce Order TO iPaaS.com keep the condition that skips records carrying an invoice number.
Additional Notes
Invoice is recorded on its Invoice Transaction. The invoice updates the Invoice Transaction that created it (a child of the order), keeping that transaction's header values. It never creates a record.
Outbound direction. Creating invoices in BigCommerce from iPaaS.com is documented separately in the companion iPaaS.com to BigCommerce B2B Invoice Mapping Documentation.
Related Documents
Related Mapping Documentation
