Configure Schema in Acumatica

Configuring Schema in Acumatica

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

Establishing Product Sync Schema

Navigate to the Commerce 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
    • Packaging
    • Cross Reference Details
  3. Toggle the Active box on for all Schema and Display Names applicable.
  4. Click Save.

Figure 3 – The Product Schema screen in Acumatica

The selected schema will be active for syncs between the commerce platform 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 the commerce platform. Product attributes will not sync if they have not been toggled on in the Schema Management section.

Establishing Category Sync Schema

Navigate to the Commerce 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.

Figure 4 – The Category Schema screen in Acumatica

The selected schema will be active for syncs between the commerce platform and Acumatica.

Establishing Customer Sync Schema

Navigate to the Commerce 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
    • Financial Settings
    • Billing Settings
    • Delivery Settings
    • Payment Methods
    • Salespersons
    • Attributes
    • Mail Settings
  3. Toggle the Active box on for all Schema and Display Names applicable.
  4. Click Save.

Figure 5 – The Customer Schema screen in Acumatica

The selected schema will be active for syncs between the commerce platform and Acumatica.