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.
- Click Refresh Schema.
- Select the tab of schema to enable. The tabs are:
- General Settings -Price/Cost Information
- Attributes
- eCommerce
- Additional Features
- Packaging
- Cross Reference Details
- Toggle the Active box on for all Schema and Display Names applicable.
- Click Save.
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.
- Click Refresh Schema.
- Select the tab of schema to enable. The tabs are:
- Category Info
- eCommerce
- Toggle the Active box on for all Schema and Display Names applicable.
- Click Save.
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.
- Click Refresh Schema.
- Select the tab of schema to enable. The tabs are:
- General Info
- Billing Settings
- Delivery Settings
- Payment Methods
- Salespersons
- Attributes
- Activities
- Mail Settings
- Toggle the Active box on for all Schema and Display Names applicable.
- Click Save.
The selected schema will be active for syncs between Magento and Acumatica.