Skip to main content

BigCommerce to iPaaS.com B2B Invoice Mapping Documentation

How BigCommerce B2B Edition invoices and their payments transfer into iPaaS.com — recorded on the order Transaction and its Transaction Payments, with poll-based capture, field mappings, and status translation.

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.comUpdate 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:

  1. A B2B invoice poll event fires, or an invoice is manually synced by its BigCommerce invoice number.

  2. The invoice is matched to its originating order Transaction through the order number; the order must already exist in iPaaS.com.

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

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

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

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

  2. Invoice without an order. Confirm an invoice whose order has not transferred does not create or update a Transaction.

  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.

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

Related Documents

Did this answer your question?