Skip to main content

BigCommerce to iPaaS.com B2B Invoice Mapping Documentation

How invoices created from iPaaS.com come back from BigCommerce B2B Edition onto their Invoice Transaction, with their payments — the supported flow, poll-based capture, field mappings, and status translation.

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:

  1. 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.

  2. A B2B invoice poll event fires, or the invoice is manually synced by {invoice ID}_INVOICE.

  3. The invoice is matched to its Invoice Transaction through that external ID. An invoice without the link is skipped.

  4. 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.

  5. 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

"Invoice"

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

  1. 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.

  2. 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.

  3. Status translation. Confirm a paid invoice sets the Transaction status to Complete and an unpaid one to Awaiting Payment.

  4. 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.

  5. 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

Did this answer your question?