Skip to main content

Automatic product creation (Acumatica ERP Integration)

A
Written by Anna Verbichenko
Updated this week

The Acumatica ERP Integration add-on can automatically create products in Acumatica ERP when synchronizing an X-Cart order with an Acumatica Sales Order.

This functionality is useful when products included in an X-Cart order do not yet exist in the Acumatica product catalog.

In the current integration model, the primary product data is maintained in Acumatica ERP. During order synchronization, the integration attempts to match X-Cart products with existing Acumatica products before creating new ones.

Product identification

Products are matched between X-Cart and Acumatica using the following identifiers:

X-Cart Product

Acumatica Stock Item

SKU

Inventory ID

When an order is synchronized, the integration searches for a matching Stock Item in Acumatica using the product SKU from X-Cart.

  • If a matching product is found, the existing Stock Item is used in the Acumatica Sales Order.

  • If no matching product is found, the integration may create a new Stock Item in Acumatica, depending on the configuration.


Create new products setting

The behavior of product creation is controlled by the Create new products setting in the Data Sync Options section of the integration configuration.

If Create new products is set to On and a product from the X-Cart order cannot be found in Acumatica, the integration will attempt to create a new Stock Item in Acumatica.

The integration sends only a minimal set of product data required to create the product in Acumatica. Additional product information can later be added in Acumatica manually or through other integrations.

If Create new products is set to Off and a product from the X-Cart order cannot be found in Acumatica, the order synchronization will fail.


When product creation occurs

Automatic product creation occurs as part of the order synchronization process. During this process, the integration verifies that all products from the order exist in Acumatica. If a product cannot be found and the Create new products option is enabled, a new Stock Item is created before the Sales Order is generated.


Can't find answers you're looking for?

Email us at support@x-cart.com. We will be happy to help!


Did this answer your question?