BigCommerce Stores

A check box that indicates (if selected) that the store configuration is active and the entities activated and configured for this store are synchronized between MYOB Acumatica and the store.

For inactive stores, you can modify the store settings on the current form, but entities are not synchronized; you can see the history of the synchronization of entities on the Sync History (BC301000) form.

If multiple stores have been configured on this form and on the Shopify Stores (BC201010) form, if applicable, when you open other commerce-related forms, the store you have defined as the default is automatically inserted in the Store box.

The system requires a store to be defined as the default store. When you are defining the first store in the system—on this form or on the Shopify Stores (BC201010) form—this check box is selected automatically. When you define another store, this check box is cleared by default; if you select this check box for the store being defined, the system clears this check box for the store that was previously defined as the default store.

The administrator URL of the BigCommerce store—that is, the store's permanent URL followed by /manage.

MYOB Acumatica uses this path when a user navigates to BigCommerce pages from the Sync History (BC301000) and Process Data (BC501500) forms.

An access token provided by BigCommerce when a new store is set up on the BigCommerce platform.

The access token should have the necessary access permissions in BigCommerce for synchronization to work properly.

The password that is used to connect to the BigCommerce file storage.

The WebDAV password is a string of random letters and numbers. You can find this password on the File Access page of the BigCommerce control panel.

The locale of MYOB Acumatica to be synchronized with the BigCommerce store.

If multiple locales have been configured in MYOB Acumatica and data is maintained in multiple languages, in this box, you select the locale that will be synchronized with the BigCommerce store.

The entity that can be synchronized between MYOB Acumatica and the BigCommerce store, which is one of the following:

• Customer Price Class
• Customer

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Customer Entity.

• Customer Location

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Customer Location Entity.

• Sales Category

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Sales Category Entity.

• Stock Item

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Stock Item Entity.

• Non-Stock Item

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Non-Stock Item Entity.

• Template Item

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Template Item Entity.

• Base Sales Price
• Price List
• Product Image
• Product Availability

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Product Availability Entity.

• Sales Order

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Sales Order Entity.

• Payment

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Payment Entity.

• Shipment

  For information about the data that is synchronized as part of this entity and standard mapping of fields, see Shipment Entity.

• Refund

You can click the link with each entity name to open the Entities (BC202000) form in a pop-up window and specify the mapping and filtering settings for the entity.

The direction in which the entity should be synchronized. The direction can be one of the following:

• Export: Data is exported from MYOB Acumatica to the BigCommerce store.
• Import: Data is imported to MYOB Acumatica from the BigCommerce store.
• Bidirectional: Data is synchronized between MYOB Acumatica and the BigCommerce store in both directions.

The direction of the synchronization is predefined by the system and cannot be changed for the following entities:

• Stock Item (predefined as Export)
• Non-Stock Item (predefined as Export)
• Template Item (predefined as Export)
• Base Sales Price (predefined as Export)
• Price List (predefined as Export)
• Product Image (predefined as Export)
• Product Availability (predefined as Export)
• Payment (predefined as Import)
• Shipment (predefined as Import)

The system that is used as the source of data during the synchronization of entities. If bidirectional synchronization is selected for the entity, the data of the primary system takes precedence if any conflicts arise during the synchronization.

The primary system can be either of the following:

• ERP (that is, MYOB Acumatica)
• External System (that is, the BigCommerce store)

The primary system is determined based on the Sync Direction setting as follows:

• For Export, ERP is set to be the primary system and cannot be changed.
• For Import, External System is set to be the primary system and cannot be changed.
• For Bidirectional, you can select which system should be used as the primary system based on your processes.

The status of the real-time import for the entity. The status can be one of the following options:

• Stopped: Real-time synchronization has not been started for the Import direction.
• Running: Real-time synchronization has been started for the Import direction.
• Not Supported: Real-time synchronization cannot be started for the Import direction.

The status of the real-time export for the entity. The status can be one of the following:

• Stopped: Real-time synchronization has not been started for the Export direction.
• Running: Real-time synchronization has been started for the Export direction.
• Not Supported: Real-time synchronization cannot be started for the Export direction.

The mode of the processing of the 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.

The maximum number of errors allowed during the import or export of data before the synchronization record is skipped (that is, excluded from further synchronization).

By default, the column contains 5: That is, the system allows 5 failed attempts before excluding the synchronization record from further processing.

The template that is used to provide the identifiers of new customers imported to MYOB Acumatica from the BigCommerce store. This character string, such as ____-____-######, initially shows the number and length of segments in the CUSTOMER segmented key, which is configured on the Segmented Keys (CS202000) form and defines the structure of the identifiers used for customers in MYOB Acumatica. The groups of underscores represent the constant segments, and the number signs represent the auto-numbered segment.

You replace the underscores with the values of the constant segments to be used in the identifiers of the customers imported from the BigCommerce store, as shown in the following example: ECUS-RET1-######. With this setting, the identifiers of all customers imported from BigCommerce to MYOB Acumatica would start with ECUS-RET1, for easy identification, and the system would automatically assign the numerical part of the identifier according to the numbering sequence selected in the Customer Numbering Sequence box. These settings do not affect the assignment of identifiers to other customers in the system (those that already exist or those that are created directly in MYOB Acumatica).

This box is available for editing only if the CUSTOMER segmented key has more than one segment.

If you will be importing customers from an online store, one of the segments of the CUSTOMER segmented key must be automatically numbered.

The numbering sequence that the system uses to automatically generate identifiers for customers imported from the BigCommerce store.

If the CUSTOMER segmented key consists of more than one segment, the numbering sequence that you select in this box applies to the automatically numbered segment (the group of number signs in the Customer Numbering Template box). The length of the numbering sequence must match the length of the auto-numbered segment.

Selecting a numbering sequence in this box does not change the Numbering ID setting of the CUSTOMER segmented key on the Segmented Keys (CS202000) form. The selected numbering sequence applies only to customers that are imported from the BigCommerce store and does not affect the assignment of identifiers to other customers in the system (those that already exist or those that are created directly in MYOB Acumatica).

The template that is used to provide the identifiers of new customer locations imported to MYOB Acumatica from the BigCommerce store. This character string, such as ____-____-######, initially shows the number and length of segments in the LOCATION segmented key, which is configured on the Segmented Keys (CS202000) form and defines the structure of the identifiers used for customer locations in MYOB Acumatica. The underscores represent the constant segments, and the number signs represent the automatically numbered segment.

You replace the underscores with values of the constant segments to be used in the identifiers of the customer locations imported from the BigCommerce store, as shown in the following example: ECUS-RET1-######. With this setting, the identifiers of all customer locations imported from BigCommerce to MYOB Acumatica would start with ECUS-RET1, for easy identification, and the system would automatically assign the numerical part of the identifier according to the numbering sequence selected in the Location Numbering Sequence box. These settings do not affect the assignment of identifiers to other customer locations in the system (those that already exist or those that are created directly in MYOB Acumatica).

This box is available for editing only if the LOCATION segmented key has more than one segment.

If you will be importing customer locations from an online store, one of the segments of the LOCATION segmented key must be automatically numbered.

The numbering sequence that the system uses to automatically generate identifiers for customer locations imported from the BigCommerce store.

If the LOCATION segmented key consists of more than one segment, the numbering sequence that you select in this box applies to the automatically numbered segment (the group of number signs in the Location Numbering Template box). The length of the numbering sequence must match the length of the auto-numbered segment.

Selecting a numbering sequence in this box does not change the Numbering ID setting of the LOCATION segmented key on the Segmented Keys (CS202000) form. The selected numbering sequence applies to only customer locations that are imported from the BigCommerce store and does not affect the assignment of identifiers to other customer locations in the system (those that already exist or those that are created directly in MYOB Acumatica).

A check box that indicates (if selected) that multiple guest customer accounts should be created to record imported guest sales orders.

When this check box is selected, the system limits the number of sales orders that can be created in MYOB Acumatica for the customer account selected in the Generic Guest Customer 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"/>

The item sales categories that are assigned by default to exported stock items that do not have item sales categories assigned in MYOB Acumatica.

In the multiselect drop-down list, you select the check box of each item sales category to be assigned to these items, and the system displays the selected categories in the box, separated by commas. The categories available for selection are those that have been defined on the Item Sales Categories (IN204060) form.

Sales categories are synchronized during the synchronization of the Sales Category entity.

During the synchronization of stock items, sales categories are assigned to exported stock items only if the Sales Category entity is activated on the Entity Settings tab of the BigCommerce Stores (BC201000) form.

The item sales categories that are assigned by default to exported non-stock items that do not have item sales categories assigned in MYOB Acumatica.

In the multiselect drop-down list, you select the check box of each item sales category to be assigned to these items, and the system displays the selected categories in the box, separated by commas. The categories available for selection are those that have been defined on the Item Sales Categories (IN204060) form.

Sales categories are synchronized during the synchronization of the Sales Category entity.

During the synchronization of non-stock items, sales categories are assigned to exported non-stock items only if the Sales Category entity is activated on the Entity Settings tab of the BigCommerce Stores (BC201000) form.

The types of related item information that can be exported to the BigCommerce store. In the multiselect drop-down list, you select the check box of each type of related items to be exported, and the system displays the selected related item types in the box, separated by commas. You can select any of the following types:

• Cross-Sell
• Up-Sell
• Substitute
• Other

• Visible: The items are visible on the storefront immediately after synchronization with the store.
• Featured: The items are visible on the storefront and are listed among featured products displayed on the front page of the store.
• Invisible: The items are exported to the product list of the external e-commerce system but do not appear on the storefront.

• Set as Available (Track Qty.): The exported items are available in the BigCommerce store, and their quantities are tracked.
• Set as Available (Don't Track Qty.): The exported items are available in the BigCommerce store, and their quantities are not tracked.
• Set as Pre-Order: The exported items are available for pre-order.
• Do Not Update: The availability status and the available quantities of items are not updated in the store.
• Set as Unavailable: The exported items are marked as unavailable for purchasing.

The default availability can be overridden for each particular item on the eCommerce tab of Stock Items (IN202500), Non-Stock Items (IN202000), or Template Items (IN203000) form.

• Do Nothing: No action should be performed. The item's availability settings in the store remain unchanged.
• Set as Unavailable: The item should be made unavailable for purchasing.
• Set as Pre-Order: The item should be made available for pre-order.

This box is available only if the Default Availability is set to Set as Available (Track Qty.).

The setting is applied to products in BigCommerce during the synchronization of the Product Availability entity.

The type of item quantity that is exported to the BigCommerce store during the synchronization of the Product Availability entity. You can select one of the following options:

• Available: The item's available quantity in BigCommerce is based on the entire available quantity of the item in MYOB Acumatica.
• Available for Shipping: The item's available quantity in BigCommerce is based on the quantity available for shipping in MYOB Acumatica.
• On Hand: The item's available quantity in BigCommerce is based on the on-hand quantity in MYOB Acumatica.

For information about availability calculation in MYOB Acumatica, see Availability Calculation Rules: General Information.

An option that determines whether all warehouses or specific warehouses and locations are used for determining the available quantity of the item in the BigCommerce store.

You can select one of the following options:

• All Warehouses: The available quantity of the item is calculated based on the on-hand quantity of the item in all warehouses.
• Specific Warehouses: The available quantity of the item is calculated based on the on-hand quantity in the selected warehouses and warehouse locations. If this option is selected, a list of warehouses and warehouse locations to be used should be specified in the Warehouse Settings table, which appears when you select this option.

The identifier of the warehouse in MYOB Acumatica whose item quantity should be used for calculating the item's available quantity in the BigCommerce store.

You can select a warehouse from the list, which contains all active warehouses that have been created on the Warehouses (IN204000) form.

The identifier of the warehouse location in MYOB Acumatica that contains inventory items whose availability data should be exported to the BigCommerce store.

If you specify a location, only this specific location of the selected warehouse is used. If no location is selected, the system exports the availability data for items stored in all locations of the selected warehouse.

You can select a warehouse location from the list of locations that have been created on the Warehouses (IN204000) form for the warehouse selected in the Warehouse column. The list displays only the locations that are active and sales from which are allowed—that is, the locations for which the Active and Sales Allowed check boxes are selected on the Locations tab of the Warehouses (IN204000) form.

The branch that is inserted in the sales orders and payments imported to MYOB Acumatica from the BigCommerce store.

The base currency of the branch must match the default currency of the BigCommerce store, which is displayed in the Default Currency box of the Store Properties section on the Connection Settings tab.

The order type in MYOB Acumatica that is assigned to imported sales orders to indicate that the orders have originated in the BigCommerce store.

The types of orders in MYOB Acumatica to be exported to the BigCommerce store.

Orders of these types are exported to the BigCommerce store only if the synchronization direction of the Sales Order entity is set to Export or Bidirectional for that store on this form or on the Entities (BC202000) form.

This box is available only if the Custom Order Types feature is enabled on the Enable/Disable Features (CS100000) form.

• Automation Behavior: RMA Order
• Default Operation: Receipt
• AR Document Type: Credit Memo

• Line Discounts: Discounts applied to the order are distributed between the sales order lines and appear in the Discount Amount column on the Details tab of the Sales Orders (SO301000) form.
• Document Discounts: Discounts applied to the order are aggregated and displayed on the Discounts tab of the Sales Orders (SO301000) form.
  Note: You can select this option only if the Customer Discounts feature is enabled on the Enable/Disable Features (CS100000) form.

The non-stock item in MYOB Acumatica that is used to represent gift wrapping in sales orders, shipments, and invoices. This item is excluded from synchronization (that is, it is not exported to the BigCommerce store during the synchronization of the Non-Stock Item entity).

On the Non-Stock Items (IN202000) form, this non-stock item must have the Non-Stock Item or Service type (tin the Item Defaults section of the General tab of the form) and the Active, No Purchases, or No Request item status (in the Summary area).

The tax zone that is assigned by default to each sales order imported to MYOB Acumatica from the BigCommerce store if no other tax zone has been identified during the import of the order.

The box is available if the Tax Synchronization check box is selected.

A check box that you select to indicate that the tax zone selected in the Default Tax Zone box should be assigned to each sales order imported to MYOB Acumatica from the BigCommerce store, regardless of whether any other tax zone has been identified during the import of the order.

This box is available if the Default Tax Zone is specified.

The substitution list to be used for mapping tax IDs between MYOB Acumatica and the BigCommerce store.

During the import of each sales order, if the system cannot find the tax ID specified in the order, it checks if there is a mapped tax ID in the substitution list specified in this box.

By default, the BCCTAXCODES substitution list is selected in this box. Substitution lists are defined on the Substitution Lists (SM206026) form.

The substitution list to be used for mapping tax categories MYOB Acumatica with tax classes in the BigCommerce store.

During the import of a sales order, if the system cannot find the tax category specified in the order, it checks if there is a mapped tax category in the substitution list specified in this box.

By default, the BCCTAXCLASSES substitution list is selected in this box. Substitution lists are defined on the Substitution Lists (SM206026) form.

The substitution list to be used for mapping Ship Via codes with shipping carrier names in the BigCommerce store.

During the synchronization of the Shipment entity with the BigCommerce 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.

By default, the BCCCARRIERS substitution list is selected in this box. Substitution lists are defined on the Substitution Lists (SM206026) form.

A check box that indicates (if selected) that payment processing is enabled for the payment method.

If this check box is cleared for a payment method, when an order is placed in the BigCommerce store and this payment method is selected at checkout, the corresponding payment is not imported from the BigCommerce store to MYOB Acumatica.

This check box is cleared by default.

The payment method defined in the BigCommerce store. This column is populated automatically. However, you can manually add additional mappings of payment options, if necessary.

The system populates the table with the following store payment methods even if these store payment methods have not been configured in the BigCommerce store:

• AMAZON
• GIFTCERTIFICATE (GIFT_CERTIFICATE)
• PAYPAL
• STORECREDIT (STORE_CREDIT)
• TEST PAYMENT GATEWAY

The currency for which the store payment method has been defined in the BigCommerce store.

You can select a currency from the list of active currencies defined on the Currencies (CM202000) form. This column is filled in automatically for store payment methods that are added to the table automatically by the API.

The identifier of the payment method in MYOB Acumatica. This payment method is used to create payment documents in MYOB Acumatica for imported payments based on the store payment method.

If you click this identifier, the system opens the payment method on the Payment Methods (CA204000) form.

The identifier of the cash account associated with the payment method in MYOB Acumatica. You can select only cash accounts in the store currency.

If you click this identifier, the system opens the cash account on the Cash Accounts (CA202000) form.

The identifier of the processing center configured in MYOB Acumatica for the card-based payment method selected in the ERP Payment Method column and the cash account selected in the Cash Account column.

If you click this identifier, the system opens the processing center on the Processing Centers (CA205000) form.

This column is displayed if the Integrated Card Processing feature is enabled on the Enable/Disable Features (CS100000) form.

A check box that you select to indicate that payments and refunds should be automatically released as soon as they are imported to MYOB Acumatica.

If this check box is selected for a card-based payment method associated with a credit card processing center in MYOB Acumatica (that is, for a payment method for which a processing center is selected in the Proc. Center ID column), only payments that have been captured in the store will be automatically released on import.

A check box that you select to indicate that refunds issued in the store for the store payment method should be imported to MYOB Acumatica.

This check box is selected and unavailable for a card-based store payment method (for example, Authorize.Net) that is mapped to a payment method in MYOB Acumatica for which a processing center has been configured on the Processing Centers (CA205000) form and specified in the Proc. Center ID column of this table.

A check box that indicates (if selected) that if a payment is imported from the BigCommerce store without payment details, the system should create a payment in MYOB Acumatica based on the information from the imported sales order.

This check box is selected by default for the following store payment methods:

• AMAZON
• PAYPAL
• TEST PAYMENT GATEWAY

For card-based payment methods with integrated card processing (that is, for card-based payment methods for which a processing center has been configured and selected in the table), this check box is cleared and unavailable.

This column is hidden by default.

The payment method that is specified in the store order.

This column is hidden by default.

The shipping zone that has been set up in the BigCommerce store.

The shipping method for the specified shipping zone that has been set up in the BigCommerce store.

For each store shipping zone, one of the values in this column is always None even though this shipping method does not exist in the BigCommerce store.

The value selected in this column is assigned to orders imported into MYOB Acumatica and is displayed on the Shipping tab of the Sales Orders (SO301000) form for these orders.

If you click code, the system opens the Ship via Codes (CS207500) form, on which you can review the Ship Via code's details.

The identifier of the shipping zone in MYOB Acumatica, which is defined on the Shipping Zones (CS207510) form, that is mapped to the combination of the store shipping zone and the store shipping method. The value selected in this column is assigned to each sales order imported to MYOB Acumatica with the store shipping zone and store shipping method specified in this row. This value is also inserted on the Shipping tab of the Sales Orders (SO301000) form for the sales order.

This value is optional. If you leave it empty, the Shipping Zone box on the Shipping tab of the Sales Orders (SO301000) form will not be populated when a sales order with the store shipping zone and store shipping method specified in the row is imported.

If you click this identifier, the system opens the shipping zone on the Shipping Zones (CS207510) form.

The identifier of the shipping terms in MYOB Acumatica, which is defined on the Shipping Terms (CS208000) form, that is mapped to the combination of the store shipping zone and store shipping method. The value selected in this column is assigned to each sales order imported to MYOB Acumatica with the store shipping zone and store shipping method specified in this row. This value is also inserted in the Shipping Terms box on the Shipping tab of the Sales Orders (SO301000) form for the sales order.

This value is optional. If you leave it empty, the Shipping Terms box on the Shipping tab of the Sales Orders (SO301000) form will not be populated when a sales order with the store shipping zone and store shipping method specified in the row is imported.

If you click this identifier, the system opens the shipping terms on the Shipping Terms (CS208000) form.