Summary
BigCommerce B2B Edition invoices and their payments transfer into iPaaS.com. An invoice is captured onto the Transaction that represents its originating order — adding the invoice's external ID, due date, open balance, and status — and the payments applied to the invoice are captured as Transaction Payments on that Transaction. 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
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 is recorded on the same Transaction as its originating order — it does not create a separate record. The payment collection is a child of the invoice collection.
ID Format
Manual Sync ID Format
Invoice: enter the BigCommerce B2B invoice number — the identifier BigCommerce assigns to the invoice.
Invoice payments have no independent Manual Sync entry point; they transfer as part of the parent invoice.
External ID Format
The invoice's BigCommerce external ID is recorded on the Transaction (through the BC B2B Invoice External ID field), and each payment's BigCommerce identifier is recorded on its Transaction Payment, so invoices and 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 collection updates the same Transaction that the order collections create. It runs as an Update and carries the order's existing header values forward, so it layers invoice detail onto an existing order rather than creating a competing record. Confirm the originating order has already transferred so the Transaction exists before the invoice update runs.
Collision Handling
The invoice is matched to its originating order Transaction through the parent-order link, resolved from the invoice's order number. It does not create a new Transaction. 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.
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
Existing order required. The invoice updates the Transaction created by its originating order. An invoice whose order has never transferred has no Transaction to update.
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. 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 the BigCommerce Installation Instructions for the poll-event setup steps.
Integration Flow
Invoice and its payments:
A B2B invoice poll event fires, or an invoice is manually synced by its BigCommerce invoice number.
The invoice is matched to its originating order Transaction through the order number; the order must already exist in iPaaS.com.
The invoice's external ID, due date, open balance, and status are recorded on the Transaction, and the order's existing header values are preserved.
Each payment applied to the invoice is captured as a Transaction Payment on the 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 originating order's Transaction. It runs as an Update: the identity and financial header fields are carried forward from the existing Transaction, while the invoice-specific fields (external ID, 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 | Recommended. The invoice's BigCommerce external identifier, used to match the invoice on later transfers. |
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. Preserves the Transaction's existing source system. |
Dynamic Formula | DestinationValue (preserve) | TransactionNumber | Recommended. Preserves the existing Transaction number so the update targets the correct order. |
Dynamic Formula | resolves parent order from Invoice_OrderNumber | ParentId | Recommended. Links the invoice to its originating order Transaction. The order must already exist in iPaaS.com. |
Dynamic Formula | DestinationValue (preserve) | CustomerId | Recommended. Preserves the buyer already recorded on the order. |
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. Preserves the order's email address. |
Dynamic Formula | DestinationValue (preserve) | DiscountAmount | Recommended. Preserves the order's discount amount. |
Dynamic Formula | DestinationValue (preserve) | TaxAmount | Recommended. Preserves the order's tax amount. |
Dynamic Formula | DestinationValue (preserve) | ShippingAmount | Recommended. Preserves the order's shipping amount. |
Dynamic Formula | DestinationValue (preserve) | Subtotal | Recommended. Preserves the order's subtotal. |
Dynamic Formula | DestinationValue (preserve) | Total | Recommended. Preserves the order's grand total. |
Dynamic Formula | DestinationValue (preserve) | TotalQty | Recommended. Preserves the order's total item quantity. |
Dynamic Formula | DestinationValue (preserve) | TransactionCreatedDateTime | Recommended. Preserves the order's original creation date/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's Transaction. This is a child of the invoice collection.
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
Invoice capture. Poll (or manually sync) a BigCommerce B2B invoice and verify its external ID, due date, open balance, and status are recorded on the originating order's Transaction, and the order's header values are preserved.
Invoice without an order. Confirm an invoice whose order has not transferred does not create or update a Transaction.
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.
Originating orders transfer before their invoices so the Transaction exists.
Additional Notes
Invoice is recorded on the order Transaction. The invoice does not create a separate record; it layers onto the order's Transaction and preserves the order's header values.
Outbound direction. Creating invoices in BigCommerce from iPaaS.com is documented separately in the companion iPaaS.com to BigCommerce B2B Invoice Mapping Documentation.
