Order Synchronization: General Information

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

Learning Objectives

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

  • Configure the synchronization of orders between MYOB Advanced and the BigCommerce store
  • Configure the synchronization of payments between MYOB Advanced and the BigCommerce store
  • Import sales orders with payments from the BigCommerce store to MYOB Advanced
  • Configure the card payment processing in MYOB Advanced 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 Advanced 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 Advanced.

If shipments created and processed in MYOB Advanced 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 Advanced. The order time zone is needed to determine the correct date and time of the order if MYOB Advanced 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 Advanced, you might want to prevent old orders from being imported to MYOB Advanced 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 Advanced 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 Advanced 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 Advanced, the MYOB Advanced 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 Advanced 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 Advanced:

  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 Advanced. During the import of a sales order, the system searches for an inventory ID of an inventory item in MYOB Advanced 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 Advanced. 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 Advanced 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 Advanced from a BigCommerce store where it was placed and paid by a manual payment method or a card payment method without integrated card processing.