Acumatica is a complete cloud Enterprise Resource Planning (ERP) for all the business management needs of ecommerce companies, including accounting, inventory management, and CRM. It helps small and mid-sized retailers provide a multi-channel ordering experience, improve the in-store experience, and automate how online sales orders are taken and fulfilled, all while improving operating efficiency. Acumatica can accommodate the needs of a single location or multi-channel sellers.
Interested in an account? Take the Free Product Tour on Acumatica's page to learn more!
Requirements to connect an Acumatica store to ShipStation:
-
You must import and publish the ShipStation customization package in your Acumatica Instance.
-
Have your Acumatica Base URL, Username, Password, Company Name, Company ID.
-
You must use one of these supported Acumatica V2 versions:
-
25 R100 v250604 or 25.100.0054_250905, both attachments found at the end of this article.
-
Scope of Support
Installing the customization package for 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 customization 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.
To connect your Acumatica store to ShipStation:
-
Download and install the ShipStation customization package to your Acumatica Instance.
Note
Customization 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:
See the attached guides for customization package installation instructions.
If you need assistance installing the customization package, please contact your Acumatica consultant / VAR.
-
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.
-
Select the Acumatica tile.
-
Use the dropdown to select the Acumatica integration version.
-
SHIPSTATIONACUMATICA[25.200.0248][251209,
SHIPSTATIONACUMATICA[25.100.0054][251209],
SHIPSTATIONACUMATICA[24.117.0035][251209], or
SHIPSTATIONACUMATICA[24.215.0011][251209]
-
-
Enter the Base URL for your Acumatica account, and an admin Username and Password.
-
Enter your Company Name. Use your Acumatica Tenant Name in this field.
You can locate the Tenant Name in Acumatica by going to
System > Explore > Tenants. -
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
-
-
Click Connect.
After you've completed the connection steps, the store's Settings page will open. You can adjust your store-specific settings like branding and customer notifications, if you wish. Or click Save to close.
The ShipStation integration with Acumatica supports the following standard features:
|
Feature |
Supported? |
|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
ShipStation Status |
Acumatica Status |
|---|---|
|
Awaiting Payment |
Unpaid |
|
Awaiting Shipment |
Open |
|
Shipped |
|
|
Cancelled |
Cancelled |
|
On Hold |
Hold |
This table indicates which data ShipStation sends to Acumatica with the marketplace shipment notification:
|
Field |
Sent to Marketplace? |
|---|---|
|
Status Update |
|
|
Tracking Number |
|
|
Carrier |
|
|
Service |
|
|
Carrier Fee |
|
|
|
|
|
Item Information |
|
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. |
-
Editing orders or shipments after export: Once a shipment or order is exported to ShipStation, changes made in either system are not synced back. If you need to make changes after export, you must update both systems manually.
The following table outlines the manual steps required to keep Acumatica and ShipStation synchronized when changes occur after the initial data export.
Scenario
Required Action
Editing Orders/Shipments
Manually update the records in both systems; changes will not sync automatically after export.
Voiding a Label
Void the label in ShipStation, then manually correct or cancel the shipment record in Acumatica.
Cancelling an Order
Cancel or delete the sales order in Acumatica, then manually cancel the corresponding order in ShipStation.
-
Split Orders: ShipStation does not allow you to split orders in Acumatica, and it does not support the import of split orders from Acumatica. If you must split an order, please do so within ShipStation, not in Acumatica.
-
Split Orders - Prepare Invoice: If you have split an order in ShipStation, do not do a Prepare Invoice until all items or packages have been shipped and are associated with a tracking number.
-
Set Package: 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.
If orders aren’t importing or you’re seeing store connection errors, use the troubleshooting guidance below to identify the cause and resolve the issue.
|
Issue |
How to troubleshoot or resolve |
|||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
The order age or shipment date in ShipStation does not match Acumatica. |
Orders and shipments are exported with a default time of 00:00, which can cause the Age field in ShipStation to appear different from Acumatica. This does not affect order processing. If the order date is also mismatched, verify that the time zone in your ShipStation store settings matches your Acumatica server time zone. |
|||||||||
|
Orders are not importing after clicking Reload. |
Understanding Refresh vs. Import To ensure your data is current, it is important to distinguish between the two different refresh functions within ShipStation. The following table clarifies which control to use based on whether you need to update your current view or pull in new data from Acumatica.
|
|||||||||
|
Connection timeout after upgrade |
If you have upgraded your Acumatica package to 23R1 or 23R2 and are experiencing a connection timeout, refusal, or unauthorized message, follow these steps to resolve the issue: Go to Web Service Endpoints and click on KNShipStationEndpoint. Click Delete. Then, go to Customization Projects(SM204505)>>Shipstation package>>Customization Project Editor>>Publish>>Publish with Cleanup. |
|||||||||
|
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. |