Configure and run flows in the BigCommerce – Acumatica quickstart integration template

Kathyana Queeman

Updated October 16, 2024 06:58

Additional record mapping is required to integrate the template’s exports and imports with your BigCommerce and Acumatica apps.

You can install the BigCommerce - Acumatica quickstart template from the integrator.io Marketplace.

Acumatica items to BigCommerce products

This flow syncs your Acumatica items as BigCommerce products.

Export source: Acumatica
Import destination: BigCommerce
Built-in export: Get Acumatica items – Get all items from Acumatica that are modified since the last flow run time.
Built-in import: Import BigCommerce products – Add or Update products into BigCommerce

Setup instructions

Configure hardcode mapping for width, height, depth, type, availability, categories, and is_visible in the BigCommerce Products import.

Import mapping: Import BigCommerce products

Acumatica customers to BigCommerce customers

This flow syncs customers from Acumatica to BigCommerce.

Export source: Acumatica
Import destination: BigCommerce
Built-in export: Get Acumatica customers – Get all customers from Acumatica that are created since the last flow run time
Built-in import: Import BigCommerce customers – Add or ignore existing customers into BigCommerce with email as the lookup identifier
Built-in hook: preMapFunction
Built-in lookup: Get BigCommerce customer addresses – Get all customer addresses from BigCommerce by customer Id
Built-in import: Import BigCommerce customer addresses – Add or ignore customer address into BigCommerce with address id as the lookup identifier

Setup instructions

Configure the static mappings for State in the BigCommerce customer addresses import.

Import mapping: Import BigCommerce customers

Import mapping: preMapFunction hook

Response mapping: Import BigCommerce customers

Results mapping: Map BigCommerce Addresses

Import mapping: preMapFunction hook

Import mapping: Import BigCommerce customer addresses

BigCommerce customers to Acumatica customers

This flow syncs customers from BigCommerce to Acumatica. When a customer is created or updated in BigCommerce, the flow syncs the information to Acumatica.

Export source: BigCommerce
Import destination: Acumatica
Built-in export: Get BigCommerce customers – Get all customers from BigCommerce that are modified since the last flow run time
Built-in lookup: Get BigCommerce customers addresses by Id – Get all customers addresses from BigCommerce by id
Built-in import: Import Acumatica customers – Add or update customers into Acumatica

Setup instructions

Configure the static mappings for State in the Acumatica customers import.
Configure mappings for Status.value, CustomerClass.value, and StatementCycleID.value.

Results mapping: Get BigCommerce Addresses by Id

Import mapping: Import Acumatica customers

BigCommerce orders to Acumatica sales orders

This flow syncs orders from BigCommerce as item sales orders in Acumatica. When an order is created in BigCommerce, it syncs the information to Acumatica.

Export source: BigCommerce
Import destination: Acumatica
Built-in export: Get BigCommerce orders – Get all orders from BigCommerce that are created since the last flow run time
Built-in lookup: Get BigCommerce order products – Get all order products from BigCommerce by order id
Built-in lookup: Get BigCommerce customer by Id – Get a customer from BigCommerce by Id
Built-in lookup: Get BigCommerce customer address by Id – Get a customer address from BigCommerce by Id
Built-in lookup: Get BigCommerce order shipping address – Get a shipping address from BigCommerce by order Id
Built-in import: Import Acumatica customers – Add or update customers into Acumatica by Id
Built-in import: Import Acumatica sales orders – Add salesorders into Acumatica

Prerequisites

A single customer address book must be imported into Acumatica for Customers records. Multiple address books are not supported in Acumatica.
A single shipping address book must be imported into Acumatica for Sales orders records. Multiple shipping addresses are not supported in Acumatica.
Item SKUs in BigCommerce and Inventory Ids in Acumatica must be identical.
The Shipvia calculation method must be manual in Acumatica.

Setup instructions

Configure the static map for MainContact.Address.State.value in the Acumatica customers import.
Configure the mapping for Status.value, CustomerClass.value, StatementCycleID.value in the Acumatica customers import.
Configure the mapping for OrderType.value, BillToAddressOverride.value, BillToContactOverride.value, ShipToAddressOverride.value, ShipToContactOverride.value, Details[*].ManualDiscount.value, Details[*].UOM.value, and Details[*].Subitem.value in the Acumatica sales orders import.

Results mapping: Get BigCommerce order products

Results mapping: Get BigCommerce Customer by Id

Results mapping: Get BigCommerce order CustomerAddress by Id

Results mapping: Get BigCommerce order ShippingAddress

Import mapping: Import Acumatica customers

Response mapping: Import Acumatica customers

Import mapping: Import Acumatica sales orders

Acumatica sales orders to BigCommerce orders

This flow syncs sales orders from Acumatica to orders in BigCommerce. It also adds to or ignores the orders in BigCommerce.

Export source: Acumatica
Import destination: BigCommerce
Built-in exports: Get Acumatica sales orders – Get all sales orders from Acumatica that are modified since the last flow run time.
Built-in lookup: Get Acumatica sales order by ordernumber – Get a salesorder from Acumatica by ordernumber.
Built-in lookup: Get Acumatica customer by Id – Get a customer from Acumatica by Id.
Built-in import: Import BigCommerce customers – Add or Update customers into BigCommerce with email as the lookup identifier.
Built-in lookup: Get BigCommerce customer addresses – Get all customer addresses from BigCommerce by customerId.
Built-in import: Import customer addresses by customer Id – Add customer addresses into BigCommerce by customer Id
Built-in lookup: Get BigCommerce products by name – Get all products from BigCommerce by name.
Built-in import: Import BigCommerce orders– Add or Ignore orders into BigCommerce with ExternalRef.value as the lookup identifier.
Built-in import: Import Acumatica salesorders– Update salesorders into Acumatica with ordernumber as the lookup identifier.

Prerequisites

The Item LineDescription in Acumatica and Product name in BigCommerce must be identical.

Setup instructions

Configure static mappings for billing_address.country, billing_address.state, payment_method, status_id, shipping_addresses[*].country, shipping_addresses[*].state, and shipping_addresses[*].shipping_method in the BigCommerce customer address import and orders import.
Configure mapping for billing_address company in the BigCommerce orders import.
Configure mapping for OrderType.value in the Acumatica sales orders import.

Results mapping: Get Acumatica salesorders by ordernumber

Results mapping: Get Acumatica customer by Id

Import mapping: Import BigCommerce customers

Response mapping: Import BigCommerce customers

Results mapping: Get BigCommerce customer addresses

Import mapping: Import customer addresses by customerid

Results mapping: Get BigCommerce products by name

Import mapping: Import BigCommerce orders

Response mapping: Import BigCommerce orders

Import mapping: Import Acumatica salesorders

Acumatica shipments to BigCommerce shipments

This flow syncs the Acumatica shipments as BigCommerce shipments.

Export source: Acumatica
Import destination: BigCommerce
Built-in exports: Get Acumatica shipments – Get all shipments from Acumatica that are created since the last flow run time.
Built-in lookup: Get Acumatica shipments by shipment number – Get shipment from Acumatica by shipment number.
Built-in lookup: Get Acumatica orders by order number – Get an order from Acumatica by order number.
Built-in lookup: Get BigCommerce order products – Get all order products from BigCommerce by order Id.
Built-in import: Import BigCommerce shipments – Add shipments into BigCommerce.

Prerequisites

Sync orders in Acumatica and BigCommerce. The BigCommerce Order Id must be stored as an external reference in Acumatica.

Setup instructions

Configure the static mappings for shipping_provider in the BigCommerce shipments import.

Results mapping: Get Automatica shipments by shipment number

Results mapping: Get Acumatica orders by order number

Results mapping: Get BigCommerce order products

Import mapping: Import BigCommerce shipments

Acumatica sales invoices to BigCommerce billings

This flow syncs Acumatica sales invoices as BigCommerce billings. It updates the billings in BigCommerce.

Export source: Acumatica
Import destination: BigCommerce
Built-in exports: Get Acumatica sales invoices – Get all sales invoices from Acumatica that are modified since the last flow run time.
Built-in lookup: Get Acumatica sales invoice details – Get a sales invoice detail from Acumatica by ReferenceNbr value.
Built-in lookup: Get Acumatica sales order by order number – Get a sales order from Acumatica by order number.
Built-in import: Import BigCommerce billings (orders with status paid) – Update order status into BigCommerce with ExternalRef as the lookup identifier

Prerequisites

Sync orders in Acumatica and BigCommerce. The BigCommerce Order Id must be saved as the external reference value in Acumatica sales orders.

Setup instructions

This flow should run once a day.
Configure the mapping for Status Id in BigCommerce billings import.

Results mapping: Get Automatica sales invoice details

Results mapping: Get Acumatica sales order by order number

Import mapping: Import BigCommerce billings

Acumatica sales orders cancellation to BigCommerce orders cancellation

This flow syncs the order cancellation from Acumatica to the order cancellation in BigCommerce. It updates the Orders into BigCommerce.

Export source: Acumatica
Import destination: BigCommerce
Built-in export: Get Acumatica sales order cancellations – Get all sales orders from Acumatica that are canceled since the last flow run time.
Built-in import: Import BigCommerce orders – Update orders into BigCommerce as canceled by external reference number.

Prerequisites

Sync orders in Acumatica and BigCommerce. The BigCommerce Order Id must be stored as an external reference in Acumatica sales orders.

Setup instructions

Configure the static mapping for status_id in the BigCommerce orders import.

Import mapping: Import BigCommerce orders

BigCommerce order cancellations to Acumatica sales order cancellations

This flow syncs order cancellations from BigCommerce to sales order cancellations in Acumatica. It cancels sales orders in Acumatica.

Export source: BigCommerce
Import destination: Acumatica
Built-in export: Get BigCommerce order cancellations – Get all orders from BigCommerce that were canceled since the last flow run time.
Built-in import: Import Acumatica sales order cancellations – Update sales orders as canceled into Acumatica.

Prerequisites

Sync orders in Acumatica and BigCommerce. The BigCommerce order Id should be stored as an external reference in Acumatica sales orders.

Setup instructions

Configure dynamic mapping for OrderNbr.
Configure mappings for order type and status.

Import mapping: Import Acumatica sales order cancellations

Acumatica customer refunds to BigCommerce refunds

This flow syncs the Acumatica customer refunds to BigCommerce refunds. It updates orders in BigCommerce.

Export source: Acumatica
Import destination: BigCommerce
Built-in export: Get Acumatica payments – Get all payments from Acumatica that are created since the last flow run time.
Built-in lookup: Get Acumatica payment by Id and type – Get a payment from Acumatica by Id and type.
Built-in lookup: Get Acumatica payment Id and type – Get a payment from Acumatica by Id and type.
Built-in lookup: Get Acumatica salesorder by Id and type – Get a salesorder from Acumatica by Id and type.
Built-in import: Import BigCommerce orders – Add refunds into BigCommerce in orders with ExternalRef as the lookup identifier.

Prerequisites

Configure the mapping for Status_id in the Bigcommerce orders import.

Setup instructions

Sync Acumatica sales orders to BigCommerce orders.

Results mapping: Get Acumatica payment by Id and type

Results mapping: Get Acumatica payment Id and type

Results mapping: Get Acumatica salesorder by Id and type

Import mapping: Import BigCommerce orders