Initial Configuration: General Information

Before you can start using the e-commerce functionality of MYOB Acumatica Retail Connectors, you need to set up a Shopify store, establish a connection between the MYOB Acumatica instance and the Shopify store, and perform the initial configuration of the connection.

Learning Objectives

In this section, you will learn what general steps are involved in establishing a connection between MYOB Acumatica and the Shopify store and in performing the initial configuration of these systems.

Steps for Establishing the Store Connection and Performing the Initial Configuration

In order to connect the MYOB Acumatica instance to the Shopify store, you perform the following general steps:

  1. Set up a Shopify store.
  2. Prepare the MYOB Acumatica instance.
  3. Establish the connection to the Shopify store.
  4. Configure the entities enabled for synchronization.
  5. Start synchronizing data.

Each of these steps is described in greater detail below.

Setup of a Shopify Store

Before you can connect MYOB Acumatica to a Shopify store, you need to set up the store. For a test implementation, we recommend that you sign up for a Shopify trial account. For more information, see the Shopify pricing page.

If you are registered in the Shopify Partner Program, you can create a new development store and use it instead.

Preparation of the MYOB Acumatica Instance

During the configuration of the connection to the Shopify store, you need to specify certain values coming from the MYOB Acumatica instance, such as the numbering sequence to be used for generating the identifiers of customers imported from the Shopify store, and the payment methods that will be mapped to the payment methods configured in the Shopify store. Some of these values can be created on the fly. However, we recommend that the MYOB Acumatica instance be prepared in advance.

For more information, see Initial Configuration: To Prepare the MYOB Acumatica Instance.

Establishing of the Connection to the Shopify Store

You can establish a connection between your Shopify store and the MYOB Acumatica instance in the following ways:

Initial Configuration of the Store Connection

After you have successfully established a connection to the Shopify store, you can perform the basic required configuration. This step involves the following substeps:

  1. Activating the entities that need to be synchronized. On the Entity Settings tab of the Shopify Stores (BC201010) form, you activate the needed entities—that is, you select the Active check box in the row of each entity whose records you want to synchronize between MYOB Acumatica and the Shopify store.

    The synchronization of a particular entity may require that some other entities be synchronized as a prerequisite. When you select the Active check box for such an entity, the system automatically selects it for all other entities required as a prerequisite. Similarly, when you clear the Active check box for an entity that is a required entity for other entities, the check box becomes cleared for all dependent entities.

    In this substep, you also review the following default synchronization settings for each entity for which the Active check box is selected, and make sure the default settings are appropriate for your configuration needs:

    • Sync Direction: The direction of the synchronization, which can be Import (data is imported to MYOB Acumatica), Export (data is exported to the Shopify store), and Bidirectional (data is both exported to the Shopify store and imported to MYOB Acumatica).
    • Primary System: The system, ERP (MYOB Acumatica) or External System (the Shopify store), whose data takes precedence if conflicts occur during the synchronization.
    • Real-Time Import: The status of the real-time import process. At the time of the initial configuration, this status is either Stopped (real-time synchronization is supported but has not been started) or Not Supported (real-time synchronization cannot be started).
    • Real-Time Export: The status of the real-time export process. At the time of the initial configuration, this status is either Stopped (real-time synchronization is supported but has not been started) or Not Supported (real-time synchronization cannot be started).
    • Real-Time Mode: The mode of the processing synchronization records, which can be either of the following:
      • Prepare: As soon as a push notification about a change to data is received, the corresponding synchronization record is placed in the processing queue.
      • Prepare & Process: As soon as a push notification about a change to data is received, the corresponding synchronization record is placed in the processing queue, and the data synchronization process is immediately started for the synchronization record.
    • Max. Number of Failed Attempts: The maximum number of errors that are allowed during the import or export before the record is automatically skipped. By default, 5 attempts are allowed.

    Although most of the settings on this tab can be changed, we recommend that you leave the default values during the initial configuration. For more information about configuring synchronization, see Data Synchronization: General Information.

  2. Specifying the settings that apply to the customer synchronization. On the Customer Settings tab, you specify the settings related to the synchronization of customers and customer locations (addresses). For details, see Customer Synchronization: General Information.
  3. Specifying the settings related to the synchronization of stock, non-stock, and template items. On the Inventory Settings tab, you can define the following default settings:
    • Export of sales categories as tags for the exported items.

      You can cause the system to export sales categories assigned to a stock or non-stock item in MYOB Acumatica to be exported to the Shopify store as product tags during the synchronization of the item. To do this, on the Inventory Settings tab of the Shopify Stores (BC201010) form, you set Sales Category Export to Export as Product Tags. You can view sales categories on the Item Sales Categories (IN204060) form.

    • Default visibility of items exported to the Shopify store.

      To specify that by default items should be visible on the storefront immediately after they are exported to the store, you select Visible in the Default Visibility box. To export items but make them hidden from the storefront, you select Invisible. For information about managing visibility of exported items, see Product Synchronization: General Information.

    • Default availability of items exported to the Shopify store. For details, see Product Availability: General Information.
  4. Specifying the settings related to the synchronization of orders. You define the default order-related settings on the Order Settings tab as follows:
  5. Specifying the settings related to the synchronization of payments. On the Payment Settings tab, you map the payment methods defined in the Shopify store to the combination of the payment method and cash account defined in MYOB Acumatica. For information, see Order Synchronization: General Information and Order Synchronization: Card Payments.
  6. Specifying the settings related to the synchronization of shipments. On the Shipping Settings tab, you define the mapping of each shipping option (which is a combination of a shipping zone and shipping method) defined in Shopify to the ship via code, and optionally, shipping zone and shipping terms defined in MYOB Acumatica. The Store Shipping Zone and Store Shipping Method columns of the table are populated with the settings from Shopify when the correct API credentials are entered and saved on the Connection Settings tab.

    On the Order Settings tab, you can also specify a substitution list to map Ship Via codes with shipping carrier names in Shopify.

    During the synchronization of the Shipment entity with the Shopify store, the retail-commerce connector checks whether a substitution value exists for the Ship Via code in the substitution list. If it exists, the connector will try to generate the tracking link based on the substitution value. If the Ship Via code does not exist in the substitution list or if no substitution list is selected in the Shipping Carriers box, the retail-commerce connector exports the Ship Via code as the carrier name. The link is generated if the Ship Via code matches the carrier name.

  7. On the form toolbar, you click Save to save the settings.

Configuration of the Entities Enabled for Synchronization

For each entity that you want to synchronize between MYOB Acumatica and the Shopify store and that you have activated on the Entity Settings tab of the Shopify Stores (BC201010) form, you can also set up the mapping of custom fields for synchronization and synchronization filtering settings on the Entities (BC202000) form.

For more information about defining filtering and mapping settings for the needed entities, see Preparing Entities for Synchronization.

Synchronization of Data

After you have performed the initial configuration, you can start to synchronize data between MYOB Acumatica and the Shopify store. First, you perform manual synchronization for entities in a specific order. Then you set up synchronization to run automatically, either in real-time or according to a specific schedule. For information about synchronization, see Data Synchronization: General Information.