Order Synchronization: General Information

You can import sales orders placed in the BigCommerce store to MYOB Acumatica for further processing.

Learning Objectives

In this chapter, you will learn how to do the following:

  • Configure the synchronization of orders between MYOB Acumatica and the BigCommerce store
  • Configure the synchronization of payments between MYOB Acumatica and the BigCommerce store
  • Import sales orders with payments from the BigCommerce store to MYOB Acumatica
  • Configure the card payment processing in MYOB Acumatica and BigCommerce

Applicable Scenarios

The synchronization of orders is the main scenario for the integration between an ERP system and an external e-commerce system. You set up the import of orders from the BigCommerce store to MYOB Acumatica so that you can process the imported orders further, for example, create a shipment for it, invoice the customer, and process the payment.

Minimal Configuration of Order Synchronization

To start importing sales orders from the BigCommerce store, you need to activate the required entities and specify the minimal settings for the activated entities on the BigCommerce Stores (BC201000) form.

On the Entity Settings tab, you activate the Sales Order and Customer entities, as well as the Stock Item entity, Non-Stock Item entity, or both entities. You specify the minimal required settings for the activated entities as follows:

  • Customer: You specify the settings for customer synchronization on the Customer Settings tab. For information, see Synchronizing Customers: General Information.
  • Stock Item and Non-Stock Item: You specify the settings for the synchronization of stock and non-stock items on the Inventory Settings tab. For details, see Product Synchronization: General Information.
  • Sales Order: On the Order Settings tab, in the Branch box, you specify the branch the system will insert in imported sales orders. In the Order Type for Import box, you specify the order type that will be assigned to and provide the default settings for the imported sales orders. In the Refund Amount Item box, you specify a non-stock item to represent refund amounts in imported sales orders. On the Shipping Settings tab, you map each shipping option (which is a combination of a shipping zone and shipping method) defined in the BigCommerce store with the ship via code and, optionally, shipping zone and shipping terms defined in MYOB Acumatica.

If shipments created and processed in MYOB Acumatica for the imported order should be synchronized with the BigCommerce store, you need to activate the Shipment entity.

The Order Time Zone

While you are performing the initial configuration of the BigCommerce store, on the Order Settings tab of the BigCommerce Stores (BC201000) form, you should specify the Order Time Zone that the system will use for each sales order imported from the BigCommerce store when it is created in MYOB Acumatica. The order time zone is needed to determine the correct date and time of the order if MYOB Acumatica and the BigCommerce store are located in different time zones.

Limiting the Date Range for Order Import

If you have had the BigCommerce store for a while before implementing MYOB Acumatica, you might want to prevent old orders from being imported to MYOB Acumatica when you start synchronizing orders. On the Order Settings tab of the BigCommerce Stores (BC201000) form, you specify the Earliest Order Date. Orders created before this date in the BigCommerce store are excluded from synchronization between MYOB Acumatica and the BigCommerce store. Payments and shipments created for such orders are excluded from synchronization too.

Tracking Imported Sales Orders in the BigCommerce Store

You might want to have information about the orders that have already been imported to MYOB Acumatica available in the BigCommerce store. On the Order Settings tab of the BigCommerce Stores (BC201000) form, you select the Tag Ext. Order with ERP Order Nbr. check box. When a sales order is imported from the BigCommerce store and assigned an order number in MYOB Acumatica, the MYOB Acumatica order number is exported and saved as a metafield of the sales order in BigCommerce.

Mapping of Shipping Options

You define the mapping of each shipping option (which is a combination of a shipping zone and shipping method) defined in BigCommerce to the ship via code, and optionally, shipping zone and shipping terms defined in MYOB Acumatica the table on the Shipping Settings tab of the BigCommerce Stores (BC201000) form. The Store Shipping Zone and Store Shipping Method columns of the table are populated with the settings from BigCommerce automatically for shipping options defined in the BigCommerce store.

Synchronization of Sales Orders and Payments

Orders are imported from a BigCommerce store during the synchronization of the Sales Order entity. During the data processing stage of the order import, the system does the following in MYOB Acumatica:

  1. Creates a sales order on the Sales Orders (SO301000) form. For information about the details and settings that the system inserts in the created sales order, see Sales Order Entity.
    Attention: Note that orders that have the Archived status in the BigCommerce store are filtered during the order import. That is, for each order with this status, the system creates a synchronization record and assigns it the Filtered status on the Sync History (BC301000) form.
  2. Searches for products (that is, stock and non-stock items) included in the sales order.

    Products included in a sales order must be synchronized with or created in MYOB Acumatica. During the import of a sales order, the system searches for an inventory ID of an inventory item in MYOB Acumatica that matches the product's SKU in the BigCommerce store. If no matching inventory ID has been found, the system continues to search for a matching alternate ID. An alternate ID is an additional identifier of the item, which can be an identifier used by your company's customer or vendor, that is specified on the Cross-Reference tab of the Stock Items (IN202500) form for a stock item and of the Non-Stock Items (IN202000) form for a non-stock item. If the matching alternate ID has been found, the system inserts in the imported order an inventory item associated with this alternate ID.

  3. Searches for a customer that placed the order, and inserts it in the sales order. If the customer has been updated in the BigCommerce store, updates the customer record in MYOB Acumatica. If the customer has not been found, creates a new customer on the Customers (AR303000) form, and inserts it in the sales order.
  4. Creates a document of the Prepayment type on the Payments and Applications (AR302000) form, if the payment method used for paying the sales order in the BigCommerce store has an active mapping with a payment method defined in MYOB Acumatica on the BigCommerce Stores (BC201000) form, and applies it to the sales order.

    If the mapping of the store payment method is inactive or has not been configured, the system creates a synchronization record for the payment on the Sync History form and assigns it the Filtered status. In this case, the prepayment document is not created on the Payments and Applications form.

    For information about the synchronization of payments, see Order Synchronization: Non-Card Payments and Order Synchronization: Card Payments.

Workflow of Importing a Sales Order with a Manual Payment

The following diagram illustrates the workflow of importing a sales order to MYOB Acumatica from a BigCommerce store where it was placed and paid by a manual payment method or a card payment method without integrated card processing.



Use of the Guest Customer Account

If you want to allow placing orders in your store without providing the customer's phone number or email address and want to import such orders into MYOB Acumatica, you need to fill in the Generic Guest Customer box on the Customer Settings tab of the BigCommerce Stores (BC201000) form. This customer account appears on imported sales orders that have been placed in the BigCommerce store without customer details.

The customer record selected in the Generic Guest Customer box is not exported to the BigCommerce store during the synchronization of customers.

You can also configure the system to change a guest customer account after a particular number of sales orders have been created for this account. You do so by selecting the Use Multiple Guest Accounts check box. When the maximum allowed number of sales orders is exceeded, the system creates a new customer and inserts its identifier in the Generic Guest Customer box. The settings of the new customer account are copied from the previous generic guest customer account, and its identifier is generated based on the numbering sequence specified in the Customer Numbering Sequence box.

By default, the allowed number of sales orders per guest customer account is limited to 10,000. You can override this number by adding the MaxOrdersPerGuestAccount key to the <appSettings> section of the web.config file. For example, to change the guest customer account after every 500 sales orders, add the following key:

<add key="MaxOrdersPerGuestAccount" value="500"/>

For more information about creating a customer, see Customers: General Information.