Configuring Schema

Configuring Schema in Acumatica

The schema that is necessary to sync with Magento can be configured by the user’s needs from Acumatica to Magento. The purpose of this is to allow users to select the fields that will sync between Acumatica and Magento.

Establishing product sync schema

Navigate to the Magento Connector workspace and select Product under the Schema Management section.

  1. Click  Refresh Schema.
  2. Select the tab of schema to enable. The tabs are:
    • General Settings -Price/Cost Information
    • Attributes
    • eCommerce
    • Additional Features
    • Packaging
    • Cross Reference Details
  3. Toggle the Active box on for all  Schema and  Display Names applicable.
  4. Click  Save.

Establishing Product Schema

The selected schema will be active for syncs between Magento and Acumatica. The purpose of toggling the selected product schema in Acumatica is to ensure that only the schema that a user selects will trigger syncs. This reduces server load and optimizes communication between Acumatica and Magento. Product attributes will not sync if they have not been toggled on in the  Schema Management section.

Some fields within Product Sync Schema will be preselected upon publishing the connector package. Fields should be reviewed prior to the connector being initialized. Any new customization fields added to these tabs automatically will appear for mapping.

Establishing category sync schema

Navigate to the  Magento Connector workspace and select  Category under the  Schema Management section.

  1. Click  Refresh Schema.
  2. Select the tab of schema to enable. The tabs are:
    • Category Info
    • eCommerce
  3. Toggle the Active box on for all  Schema and  Display Names applicable.
  4. Click  Save.

Establishing Category Schema

The selected schema will be active for syncs between Magento and Acumatica.

Establishing customer sync schema

Navigate to the Magento Connector workspace and select  Customer under the  Schema Management section. Note there are two extra columns in this schema management:  API Reference Field Path and  API Input Field Name. This contains the direction and destination of the selected field using Acumatica’s API framework. These are fields that can be modified to the needs of a user based on the schema that are being synced.

  1. Click Refresh Schema.
  2. Select the tab of schema to enable. The tabs are:
    • General Info
    • Billing Settings
    • Delivery Settings
    • Payment Methods
    • Salespersons
    • Attributes
    • Activities
    • Mail Settings
  3. Toggle the Active box on for all  Schema and  Display Names applicable.
  4. Click  Save.

Establishing Customer Schema

The selected schema will be active for syncs between Magento and Acumatica.