How to Sync CommerceHub Inventory Quantities from Acumatica
To sync CommerceHub inventory quantities from Acumatica, configure the connector for the correct store, add the warehouses that should contribute inventory, choose the quantity basis, and save the applicable Inventory IDs in the Inventory Template. Those items then appear on the Export CommerceHub Inventory screen, where they can be processed through the connector's SFTP file workflow.
The connector documentation identifies three quantity choices: On Hand Quantity, Available Quantity, and Available for Shipment Quantity. That selection matters because it determines which Acumatica quantity the connector exports. A reliable CommerceHub inventory sync therefore begins with configuration, not with the export button.
How the CommerceHub Acumatica inventory integration works
The CommerceHub connector exchanges data through SFTP and text files rather than direct API requests. The documented flow sends information from Acumatica into the file-transfer layer and onward to CommerceHub. Information returning to Acumatica follows the reverse path.
Store codes separate connector configurations for different import and export processes. A store can have its own parameters, including Transaction Type, Description, Default Customer, and Document Type. The inventory process also depends on the warehouses, quantity basis, and Inventory IDs selected in the Mappings area. For inventory synchronization, use the store configuration associated with the intended CommerceHub operation.
This design creates several checkpoints. Acumatica determines which records and quantities are eligible. The Export CommerceHub Inventory screen presents the selected items. A text file carries the data through SFTP. CommerceHub must then receive and use that file. When a quantity looks wrong, check each checkpoint in sequence instead of assuming the issue is inside Acumatica.
CommerceHub inventory sync workflow
1. Confirm the connector and store configuration. After the connector is published, the CommerceHub workspace and its screens become available in Acumatica. Open the Mappings screen and select the store code that belongs to the inventory export process. Store codes can carry distinct settings, so verify that you are working in the intended configuration before changing warehouses or items.
2. Add the warehouses to Warehouse Details. Warehouse Details controls which Acumatica warehouses are included in the inventory export. Add every warehouse that should contribute a quantity and leave out warehouses that should not be represented in the CommerceHub feed. If an expected location is missing here, its inventory will not be part of the configured export scope.
3. Choose the quantity basis. Use the Quantity field in Warehouse Details to select On Hand Quantity, Available Quantity, or Available for Shipment Quantity. Choose the measure that matches the inventory value the CommerceHub operation is expected to receive. The connector documentation lists these options but does not define a universal best choice, so the correct setting depends on the business rule for that store and process.
4. Select Inventory IDs in Inventory Template. Open the Inventory Template tab, select the Inventory IDs that should be synchronized, and save the changes. Saving is essential: the documented behavior is that selected and saved Inventory IDs appear on the Export CommerceHub Inventory screen.
5. Review the export population. Open Export CommerceHub Inventory for the applicable store code. Confirm that the expected items are present before processing. If an item is absent, return first to Inventory Template and confirm that its Inventory ID was selected and saved. Then check that the correct store configuration is in use.
6. Process the inventory export. Use the export screen to process the selected inventory records. The connector writes the inventory information into the file-based SFTP flow for delivery to CommerceHub. Because this is not a direct API transaction, a successful selection in Acumatica is only one part of the end-to-end sync.
7. Validate the result. Compare the quantity expected from Acumatica with the inventory output and the quantity received in CommerceHub. Validate the same Inventory ID, store code, warehouses, and quantity basis at each point. This isolates configuration errors from file-transfer or downstream processing problems.
Fields and settings that control the export
Store Code
The store code identifies the connector configuration used for a process. Since each store can have unique parameters, selecting the wrong store code can lead you to review or process a different configuration than intended.
Warehouse Details
This area defines the warehouses to export. Treat the warehouse list as the boundary of the inventory calculation used by the connector. When troubleshooting a missing or unexpected quantity, confirm the warehouse list before investigating the transfer file.
Quantity
The Quantity field offers three documented values:
1. On Hand Quantity, which selects the on-hand measure.
2. Available Quantity, which selects the available measure.
3. Available for Shipment Quantity, which selects the amount available for shipment.
Do not treat these labels as interchangeable. Record the selected option for the store configuration and compare the export against that same Acumatica measure.
Inventory Template
Inventory Template identifies which Inventory IDs participate in synchronization. An Inventory ID must be selected and saved before the associated item appears on Export CommerceHub Inventory. This makes the template the first place to check when an item is missing from the processing screen.
Monitoring and validating the inventory sync
Monitor the process at the points the connector documentation exposes. Begin with Mappings, where the store, Warehouse Details, Quantity selection, Inventory Template, and Error Log are available. Then inspect Export CommerceHub Inventory, the SFTP transfer, and the received value in CommerceHub.
For each validation sample, capture the following values:
1. The store code used for the export.
2. The Acumatica Inventory ID selected in Inventory Template.
3. The warehouses included in Warehouse Details.
4. The selected quantity option and the corresponding Acumatica quantity.
5. The item's presence on Export CommerceHub Inventory.
6. The outbound file result and the quantity received in CommerceHub.
The Mappings screen includes an Error Log tab for messages encountered during connector import and export activity, and Purge Logs can remove all messages from that tab. Review available messages before purging them. The source specifically describes order-related errors in this area and does not define dedicated inventory error fields, so do not rely on the Error Log alone for inventory validation. Check the outbound file and CommerceHub result as well.
Common pitfalls
The item was not saved in Inventory Template
Selecting an Inventory ID without saving it will not establish the documented link to Export CommerceHub Inventory. Reopen the template and confirm that the item remains selected.
The wrong store code is selected
Store codes can have different connector parameters. Confirm the store before reviewing the item population or running the export.
A warehouse is missing or should not be included
Warehouse Details determines which warehouses belong in the export. An incomplete list can omit inventory, while an unintended warehouse can change the quantity being sent.
The quantity basis does not match the expected value
A comparison against On Hand will fail if the connector is configured to export Available or Available for Shipment. Always reconcile against the configured Quantity option.
The Acumatica step succeeded but the file flow did not
The connector uses text files and SFTP. An item can appear correctly in Acumatica while CommerceHub remains unchanged if the file is not transferred or processed. Validate the handoff after running the export.
Logs were purged before the issue was reviewed
Purge Logs removes all messages in the Error Log tab. Review and retain the information needed for troubleshooting before using it.
Frequently asked questions
Which Acumatica quantities can the connector export
The documented options are On Hand Quantity, Available Quantity, and Available for Shipment Quantity. The Quantity field in Warehouse Details controls the selection.
Why is an item missing from Export CommerceHub Inventory
Confirm that the Inventory ID is selected and saved in Inventory Template. Also verify that you opened the export screen for the intended store code.
Does the CommerceHub connector send inventory through an API
No. The connector documentation describes an SFTP process that exchanges text files. The inventory export therefore requires validation of both the Acumatica processing step and the file-transfer path.
Where are warehouses configured for the inventory export
Add them in Warehouse Details on the Mappings screen. This list identifies the warehouses that need to be exported.
Where can connector errors be reviewed
The Mappings screen includes an Error Log and a Purge Logs action. Because the documentation describes the log mainly in relation to order processing, also review the inventory export result, outbound file, and CommerceHub value when troubleshooting inventory.
How should a CommerceHub inventory quantity be validated
Use a specific item and compare the same Inventory ID, store code, warehouse scope, and configured quantity basis across Acumatica, the export output, and CommerceHub. This sequence shows whether the mismatch begins in setup, export processing, file transfer, or receipt.
Get help with CommerceHub and Acumatica integration
If you need help configuring, validating, or troubleshooting a CommerceHub inventory sync in Acumatica, contact Biz-Tech Services to discuss the connector workflow and your inventory requirements.
How to Sync EZCom Inventory Availability from Acumatica
How to Sync EZCom Inventory Availability from Acumatica
The Biz-Tech Services Acumatica EZCom Connector lets Acumatica users send inventory availability to EZCom for items configured for a trading partner. The process depends on two partner-level setups: the item must be loaded and selected on the Inventory Items tab, and its warehouse and quantity mapping must be defined on the Inventory Availability tab. Once those prerequisites are in place, users can review the eligible items on the Send Inventory Availability screen and send selected records or the full list.
Accurate setup matters because the connector does not treat inventory as a single company-wide value. It uses the mapping for the selected trading partner to determine which Acumatica warehouse and quantity option correspond to the EZCom warehouse code and item identifier. This guide explains the workflow, the fields that control it, and the checks that help confirm that quantities were sent as intended.
How the EZCom inventory availability workflow works
The connector links Acumatica ERP with the EZCom EDI platform through an intermediate server controlled by Biz-Tech Services. Connection information is entered in the connector's General Settings. When inventory availability is sent, the connector uses the relevant trading partner configuration and passes the mapped item quantity to EZCom.
The user-facing workflow begins in Trading Partners and finishes on Send Inventory Availability. First, retrieve or select the partner and confirm its item mappings. Next, define how inventory availability should be calculated and where it should be reported. Finally, open Send Inventory Availability, select the records to process, and use Send or Send All.
- Retrieve the trading partner - On the Trading Partners screen, use Get Trading Partners from Actions when the partner list has not yet been loaded. Configuration is maintained for the corresponding Partner Code.
- Map eligible inventory items - On the Inventory Items tab, map the EZCom item to the correct Acumatica Inventory ID. The connector documentation notes that the corresponding EZCom order item must be mapped for order import, and the Send Inventory Availability screen displays items already loaded and checked on this tab.
- Configure inventory availability - On the Inventory Availability tab, map the Acumatica warehouse, the quantity option, and the corresponding EZCom warehouse code or item UPC reference described in the product documentation. This mapping controls which quantity is synchronized to EZCom.
- Review items ready to send - Open Send Inventory Availability for the appropriate partner. The grid should show the items that were loaded and selected on the partner's Inventory Items tab.
- Send inventory quantities - Select one or more items and click Send, or click Send All to process every displayed item. The connector sends each quantity according to the partner's Inventory Availability mapping.
Required fields and settings
Partner Code identifies the EZCom trading partner whose rules apply. Because inventory and cross-reference settings are maintained by partner, verify the code before reviewing items or sending quantities. The Description field can provide additional partner details, but Partner Code is the lookup that selects the partner configuration.
Inventory ID is the Acumatica item associated with the partner's EZCom item. The Inventory Items tab provides the item-level cross-reference. The available lookup method depends on the enabled Cross-Reference Options. For example, the connector can search by UPC Code and associate the matching value with an Acumatica Inventory ID. Only cross-reference entities selected in the partner settings appear in the dropdown.
Acumatica Warehouse identifies the inventory location used for the availability calculation. Quantity Option determines which quantity value the connector sends. EZCom Warehouse Code establishes the destination warehouse reference on the EZCom side. The source documentation groups these values together on the Inventory Availability tab because all three are needed to determine what quantity should be synchronized and where it belongs.
API connectivity is configured in General Settings. When Modify API Connectivity is selected, the screen displays Account, API Key, Login, and Password. The account and API key are provided for each EZCom website, while the login and password are the EZCom admin-panel credentials. Use Test Credentials under Actions to verify the connection to the Acumatica-Biz-Tech server before troubleshooting item-level synchronization.
Monitoring and validating the sync
Start validation before sending. Confirm that the expected partner is selected, the item appears on the Inventory Items tab, and the item is checked. Then review the Inventory Availability mapping for the same partner. A visible item without the required warehouse and quantity mapping is not sufficient to establish the quantity that should be sent.
On the Send Inventory Availability screen, compare the displayed item list with the items you intended to publish. Send a limited selection first when validating a new setup. After clicking Send, verify the quantity in EZCom against the quantity option and Acumatica warehouse configured in the mapping. This comparison tests the full path rather than confirming only that the item appeared in the Acumatica grid.
If no items appear, return to the partner's Inventory Items tab and verify that the records were loaded and checked. If items appear but the values are unexpected, review the Inventory Availability mapping, especially the Acumatica warehouse and quantity option. If processing cannot reach EZCom, test the General Settings credentials and confirm that the Account, API Key, Login, and Password belong to the intended EZCom website.
Common pitfalls
- Configuring an item for one partner and sending from another partner. The connector applies settings for the selected Partner Code.
- Loading an item without checking it on the Inventory Items tab. The Send Inventory Availability screen is documented to show items that are already loaded and checked.
- Mapping the Inventory ID but omitting the Inventory Availability setup. The warehouse, quantity option, and EZCom warehouse reference determine the quantity synchronization.
- Assuming every cross-reference field will be available. Only entities enabled under Cross-Reference Options appear in the item mapping dropdown.
- Testing with Send All before validating a small set. Send All processes every displayed item, so a narrow first test makes mapping errors easier to isolate.
- Troubleshooting quantities before testing connectivity. Invalid or mismatched credentials can prevent the connector from reaching the intermediate server regardless of item configuration.
Frequently asked questions
Which items appear on Send Inventory Availability
The screen displays items already loaded and checked on the Inventory Items tab of Trading Partners for the corresponding partner.
What setup controls the quantity sent to EZCom
The Inventory Availability mapping controls the sync. It associates the Acumatica warehouse and quantity option with the corresponding EZCom warehouse reference for the partner.
Should I use Send or Send All
Use Send for selected items. Use Send All when every displayed item should be synchronized. For a new or revised mapping, validating selected items first reduces the scope of troubleshooting.
Why is an expected item missing from the send screen
Verify that the item has been loaded and checked on the partner's Inventory Items tab. Also confirm that you are working with the correct Partner Code.
How do I verify EZCom connectivity
Open General Settings and use Test Credentials under Actions. When API connectivity can be modified, review the Account, API Key, Login, and Password fields.
Can item matching use a UPC code
Yes. The source documentation gives UPC Code as an example of an Inventory Items cross-reference method. The option must be enabled under Cross-Reference Options before it appears in the dropdown.
Get help with EZCom and Acumatica integration
Biz-Tech Services supports Acumatica integrations, including the EZCom Connector. For help reviewing partner mappings, validating inventory availability, or resolving connector issues, visit https://biztechservices.com/.
