1. ShipStation Help Center
  2. Integrations Help Guide
  3. Stores A-C

Acumatica

Avatar

ShipStation Content Team

Updated

How to add an Acumatica store to ShipStation, what features are available, other need-to-know details, and troubleshooting tips.

Acumatica offers cloud-based Enterprise Resource Planning (ERP). While Acumatica is not a marketplace or selling channel, it does integrate with ecommerce channels like Magento. Think of it as middleware: a central hub for everything related to your ecommerce business. Connect Acumatica to ShipStation to act as your primary order source.

Interested in an account? Take the Free Product Tour on Acumatica's page to learn more!

Acumatica Requirements

Requirements to connect an Acumatica store to ShipStation:

  • You must import and publish the ShipStation Customisation package in your Acumatica Instance.

  • Have your Acumatica Base URL, Username, Password, Company Name, Company ID.

  • You must use one of these supported Acumatica versions:

    • 2020 R1, 2020 R2, 2021 R1, and 2021 R2 , 2022 R1, 2022 R2 (V2 Acumatica), 2023 R1 (V2 Acumatica)

Scope of Support

Installing the Customisation package to your Acumatica account is beyond ShipStation's scope of support. We recommend you contact your account developer or Acumatica consultant / VAR if you need assistance with the Customisation package installation process, as the process can differ based on the unique Acumatica configuration.

To import an Acumatica shipment into ShipStation, the shipment must:

  • Be in a status that is mapped within ShipStation.

  • Include a full Ship To address.

Connect an Acumatica store to ShipStation

To connect your Acumatica store to ShipStation:

  1. Download and install the ShipStation Customisation package to your Acumatica Instance.

    Note

    Customisation package files are available at the bottom of this article.

    Be sure to download the cartridge file specific to the version of Acumatica you are using:

    • Acumatica 2021 R1 (V2 Acumatica): ShipStation Acumatica2021R1.zip

    • Acumatica 2021 R2 (V2 Acumatica): ShipStation Acumatica2021R2.zip

    • Acumatica 2022 R1 (V2 Acumatica): ShipStation Acumatica2022R1.zip

    • Acumatica 2022 R2 (V2 Acumatica): ShipStation Acumatica2022R2.zip

    • Acumatica 2023 R1 (V2 Acumatica): ShipStation Acumatica2023R1.zip

    See the attached guides for Customisation package installation instructions.

    If you need assistance installing the Customisation package, please contact your Acumatica consultant / VAR.

  2. Set up Acumatica according to the instructions in the Acumatica User Guide.

    Your Acumatica account must be configured before completing the rest of the steps in this process. If you attempt to connect your Acumatica store before configuring your Acumatica account, you will receive a 500 error in ShipStation.

  3. Open a new tab or browser window and log in to your ShipStation account.

  4. Go to Account Settings.

    Closeup of ShipStation toolbar with outline marking the Settings icon.

  5. Select Selling Channels from the left-hand sidebar, then choose Store Setup.

    Settings page selections, with outline marking the Selling Channels Store Setup option.

  6. Click Connect a Store or Marketplace.

    Store Setup Settings, arrow points to Connect a Store or Marketplace button.

  7. Select the Acumatica tile.

    Acumatica logo on square tile button

  8. Use the dropdown to select the Acumatica integration version.

    • V2 Acumatica: Acumatica 2021 R1, Acumatica 2021 R2, Acumatica 2022 R1, Acumatica 2022 R2, Acumatica 2023 R1.

  9. Enter the Base URL for your Acumatica account, and an admin Username and Password.

  10. Enter your Company Name and Company ID. Use your Acumatica Tenant Name and Tenant ID for these fields.

    You can locate the Tenant Name and Tenant ID in Acumatica by going to System > Explore > Tenants.

  11. Enter your Acumatica order statuses as follows (or, if you are using custom statuses, use those instead):

    • Unpaid Status: Leave blank

    • Paid Status: Open

    • Shipped Status: Confirmed, Completed

    • Cancelled Status: Cancelled

    • On Hold Status: Hold

  12. Click Test Connection, then Connect if the test is successful.

After you've completed the connection steps, your store will be connected to ShipStation. You'll be taken to the store's Settings page to adjust the store-specific settings like branding, notification preferences, and product handling.

Available Features for Acumatica Integration

The ShipStation integration with Acumatica supports the following standard features:

Key: Green checkmark. Supported feature. Yes. = Supported; Red X mark. Unsupported feature. No. = Not Supported; Grey dash icon. Not applicable. = Does Not Apply

Common Integration Features

Feature

Supported?

Custom Statuses

Green checkmark. Supported feature. Yes.

Customer Emails

Green checkmark. Supported feature. Yes.

Customer Phone Numbers

Green checkmark. Supported feature. Yes.

Requested Service

Green checkmark. Supported feature. Yes.

Payment Method

Green checkmark. Supported feature. Yes.

Discounts

Red X mark. Unsupported feature. No.

Identifies Gift Orders

Green checkmark. Supported feature. Yes.

Internal Notes

Green checkmark. Supported feature. Yes.

Notes from Buyer

Green checkmark. Supported feature. Yes.

Order Weight

Green checkmark. Supported feature. Yes.

Item Weight

Green checkmark. Supported feature. Yes.

Item Images

Red X mark. Unsupported feature. No.

Item Options

Red X mark. Unsupported feature. No.

Item Warehouse Location

Green checkmark. Supported feature. Yes.

Order Status Mapping:

Status

Acumatica Status

Awaiting Payment

Unpaid

Awaiting Shipment

Open

Shipped

Completed, Confirmed

Cancelled

Cancelled

On Hold

Hold

Sent with Shipment Update

Field

Supported?

Status Update

Green checkmark. Supported feature. Yes.

Tracking Number

Green checkmark. Supported feature. Yes.

Carrier

Green checkmark. Supported feature. Yes.

Service

Green checkmark. Supported feature. Yes.

Carrier Fee

Green checkmark. Supported feature. Yes.

Note to Buyer

Green checkmark. Supported feature. Yes.

Item Information

Green checkmark. Supported feature. Yes.

Additional Features for Acumatica

ShipStation's integration with Acumatica allows for the following additional features:

Feature

Description

Configurable Time Zone

By default, ShipStation assumes that the Acumatica store's server uses UTC as the timezone. If your Acumatica account uses a different server timezone, define it in the store's settings.

View ShipStation Log Details in Acumatica

You can view ShipStation Log Details in Acumatica. This means that you can see from your Acumatica account when there is an error importing an order into ShipStation.

This integration allows you to define the Status Mappings for the store connection.

ShipStation will import the customer's email address with the order and can send customer shipment confirmation and delivery emails, which are configured in your Store Settings.

ShipStation will import the customer phone number.

ShipStation will import the shipping method chosen by the customer at time of checkout.

ShipStation will import the payment method used to pay for the order.

ShipStation will import discount and coupon information for the order.

ShipStation is able to determine if an order was placed as a gift.

ShipStation will import internal notes or order activity from the selling channel.

ShipStation will import notes left by the customer at time of checkout. Displayed as Customer notes in ShipStation's Legacy Layout.

ShipStation will import the total order weight from the selling channel.

ShipStation will import the weight for each line item in the order.

ShipStation will import an image URL for each line item in the order.

ShipStation will import item options (such as color or size) for each line item in the order.

ShipStation will import a product stock location for each line item in the order.

Status UpdateTracking NumberCarrierServiceCarrier Fee

The shipment update ShipStation sends to the selling channel will include any Notes to Buyer set on the order in ShipStation.

Item Information

Additional Details about the Acumatica Integration

  • The shipment in Acumatica must have a package set to receive a tracking number when ShipStation sends the shipment update. If no package exists, ShipStation will still be able to update the shipment's status, but no tracking number will be available.

    Acumatica Shipments screen with Box ID, Type, and Tracking Number fields highlighted in packages view.

Acumatica Troubleshooting Tips

Here are some common issues experienced by users, potential causes, and available troubleshooting tips.

Issue

How to troubleshoot or resolve

Error Message: “An error occurred attempting to update orders: Error in XML. Reason: The element 'Item' has incomplete content. List of possible elements expected: 'Name, Quantity, UnitPrice, SKU'.”

Add a description on your product within your Acumatica dashboard, for a successful import.

The Order Date in ShipStation is different than the Order Date in Acumatica.

This usually occurs because the Acumatica server is using a different timezone than the timezone set in the store's settings in ShipStation, which causes the Order Date to be thrown off when converting the timestamp based on time zone.

Update the store's settings so the store is using the same timezone as the server your Acumatica store is hosted on.

Orders placed late in the day are not importing into ShipStation.

Similar to the issue above, this typically occurs because the Acumatica server is using a different timezone than the timezone set in the store's settings in ShipStation, which causes our import process to inadvertently skip ahead.

Update the store's settings so the store is using the same timezone as the server your Acumatica store is hosted on.
Enterprise Resource Planning (ERP)

This integration allows you to define the Status Mappings for the store connection.

ShipStation will import the customer's email address with the order and can send customer shipment confirmation and delivery emails, which are configured in your Store Settings.

ShipStation will import the customer phone number.

ShipStation will import the shipping method chosen by the customer at time of checkout.

ShipStation will import the payment method used to pay for the order.

ShipStation will import discount and coupon information for the order.

ShipStation is able to determine if an order was placed as a gift.

ShipStation will import internal notes or order activity from the selling channel.

ShipStation will import notes left by the customer at time of checkout. Displayed as Customer notes in ShipStation's Legacy Layout.

ShipStation will import the total order weight from the selling channel.

ShipStation will import the weight for each line item in the order.

ShipStation will import an image URL for each line item in the order.

ShipStation will import item options (such as color or size) for each line item in the order.

ShipStation will import a product stock location for each line item in the order.

Status UpdateTracking NumberCarrierServiceCarrier Fee

The shipment update ShipStation sends to the selling channel will include any Notes to Buyer set on the order in ShipStation.

Item Information