1. ShipStation Help UK
  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, box highlights 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

ShipStation Status

Acumatica Status

Awaiting Payment

Unpaid

Awaiting Shipment

Open

Shipped

  • Completed

  • Confirmed

Cancelled

Cancelled

On Hold

Hold

Sent with Shipment Update

Field

Sent to marketplace?

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.

If a store allows custom statuses, this means you define that statuses your orders use in your selling channel. In most cases, if you have custom statuses you'll need to define which ShipStation statuses each custom order status corresponds to.

ShipStation will import the customer's email address with the order data and can send shipment confirmation and delivery emails to that email address (configured in your Store settings).

ShipStation will import the customer phone number with the order data.

ShipStation will import the shipping method chosen by the customer during their store checkout.

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

ShipStation will import discount and coupon information for the order.

ShipStation can determine if an order is a gift from the order data sent by the store.

ShipStation will import internal notes or order activity from the store into the ShipStation Internal Notes field.

ShipStation will import notes provided by the customer when they made their purchase.

ShipStation will import the total order weight from the store.

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. These images will appear as thumbnails in your Order Details and can be included in email notifications and packing slips.

ShipStation will import item options (such as color or size) for each line item in the order. This data will appear in your Order Details and can be included in customer emails and packing slips.

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)

If a store allows custom statuses, this means you define that statuses your orders use in your selling channel. In most cases, if you have custom statuses you'll need to define which ShipStation statuses each custom order status corresponds to.

ShipStation will import the customer's email address with the order data and can send shipment confirmation and delivery emails to that email address (configured in your Store settings).

ShipStation will import the customer phone number with the order data.

ShipStation will import the shipping method chosen by the customer during their store checkout.

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

ShipStation will import discount and coupon information for the order.

ShipStation can determine if an order is a gift from the order data sent by the store.

ShipStation will import internal notes or order activity from the store into the ShipStation Internal Notes field.

ShipStation will import notes provided by the customer when they made their purchase.

ShipStation will import the total order weight from the store.

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. These images will appear as thumbnails in your Order Details and can be included in email notifications and packing slips.

ShipStation will import item options (such as color or size) for each line item in the order. This data will appear in your Order Details and can be included in customer emails and packing slips.

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

Didn't find what you were looking for?