Overview of Shipstation Processing in Acctivate.

This help article is a general overview on how Acctivate orders are sent to ShipStation, when shipment data is sent from ShipStation to Acctivate, locating the ShipStation Logs folder, and the Acctivate/ShipStation mappings.

How are Orders sent to ShipStation?

Orders in Acctivate can be sent to ShipStation using two different methods. Directly from the Sales Order Window by clicking the "ShipStation" button, or in bulk using Order Manager. The orders must meet the following criteria in order to to be sent:

  • Only Scheduled Sales Orders are included. Credit memos and quotes are not eligible.
  • The Sales Order must be assigned a Ship Via which has a configured Carrier and Carrier Service.
  • The Sales Order must have at least one scheduled line item. This excludes Completed, Booked or Backordered Order Statuses. 
  • The Sales Order must not have a credit hold.
Sales Order (Single record) Order Manager (Bulk)

When is shipment data sent from ShipStation to Acctivate?

The sync between ShipStation and Acctivate occurs in two ways. First, ShipStation shipment data is imported periodically (every 5 minutes). This sync occurs automatically through a background process in Acctivate. Second, You can run a manual sync from Sales>Shipping Workstation Sync>Sync.  Once the shipment data is imported back into Acctivate, the Workflow Status for the order(s) is automatically updated to "Shipped" and you will see the shipment information for the order(s) on the Sales Order Packages tab. 

Where are the ShipStation Logs located?

If an Exception occurs when sending Order information to ShipStation, those Exception messages will be stored in the ShipStation Log folder.  This folder is located on the Acctivate Server in the following directory: \\Server\AcctivateData\Log\ShipStation. To enable Verbose logging for ShipStation, please visit this help article. 

How are the Shipping Address formats determined?

1) If the Sales Order ShipToAddress1 is a Company Name:

Acctivate Sales Order Shipping Address ShipStation
ShipToAddress1 If line 1 of the Shipping Address field in Acctivate matches the Company or Name (Ship Attention field), the address line 1 is ignored:
  • Address line 1: Line 2 from the Shipping Address field of the sales order.
  • Address line 2: Line 3 from the Shipping Address field of the sales order.
If line 1 of the Shipping Address field in Acctivate does not match the Company or Name (Ship Attention field):
  • Address line 1: Line 1 from the Shipping Address field of the sales order.
  • Address line 2: Line 2 from the Shipping Address field of the sales order.
ShipToAddress2 Street1
ShipToAddress3 Street2

2) If the Sales Order ShipToAddress is a Name (Determined if ShipToAddress1 is the same as ShipToAttn):

Acctivate Sales Order Shipping Address ShipStation
ShipToAddress1 Name
ShipToAddress2 Street1
ShipToAddress3 Street2

3) If ShipToAddress1 is neither a Name or Company Name, Acctivate will assume it is a name and send the data as in the case 2 example.

4) If none of the cases above are met, send Company Name or Name to ShipStation if it does not appear in the address block.

5) If you're still experiencing Address formatting issues, you can try disabling Address Validation in ShipStation settings.

What are the ShipStation/Acctivate mappings?

These mappings are not editable and are automatically configured to sync the following information from ShipStation to Acctivate. This information is initially written into the tbOrderPackagesText table and parsed out directly into other database tables.

ShipStation Subdocument ID ShipStation Field Acctivate Destination
shipment carrierCode tbShipment.Carrier
shipment serviceCode tbShipment.CarrierService
shipment shipDate tbShipment.ShipmentDate
shipment orderNumber tbShipmentOrder.OrderNumber
shipment trackingNumber tbShipment.CarrierPackageID
shipment insuredValue tbShipment.DeclaredValue
shipment insuranced tbShipment.Insured
shipment shipmentCost tbShipment.ShippingCharge
shipment voided tbShipment.Voided
shipment packageId tbShipment.WebPackageID
shipment weight_value tbShipment.Weight
fulfillment fulfillmentProviderCode tbShipment.Carrier
fulfillment fulfillmentServiceCode tbShipment.CarrierService
fulfillment shipDate tbShipment.ShipmentDate
fulfillment orderNumber tbShipmentOrder.OrderNumber
fulfillment trackingNumber tbShipmentPack.CarrierPackageID
fulfillment fulfillmentFee tbShipmentPack.ShippingCharge
fulfillment voided tbShipmentPack.Voided
fulfillment packageId tbShipmentPack.WebPackageID

For more information about ShipStation processing, check out our docs.