ShipRush connection to Acctivate

Acctivate can be integrated with the Z-Firm ShipRush shipping workstation software.  ShipRush is a great alternative to carrier shipping software, such as UPS WorldShip, FedEx Ship Manager or Stamps.com.

First, you’ll need to purchase ShipRush from Z-Firm.  Please contact ShipRush sales at sales@shiprush.com or call at (206)812-7874.

The following instructions will guide you through the integration, once you have installed ShipRush on a computer with access to the Acctivate database running on Microsoft SQL Server.

The ShipRush SQL edition is required.  You’ll only need to set up the “CM Settings” once, even if you’re using ShipRush with more than one carrier.

  1. Start ShipRush for UPS, FedEx or Stamps.com
  2. Right-click on Ship Rush system tray and choose Program Settings from Settings menu.
  3. Click the CM Settings … button
  4. Select the Getting Contact Info tab and check the Database box
  5. Click the button on the right-side of the DB Connection String field to set up the connection to the Acctivate database
    1. Choose Microsoft OLE DB Provider for SQL Server and click Next
    2. Use the drop-down to Select or enter a server name.  It’s usually COMPUTERNAME\ACCTIVATE, using the computer name for your server.
    3. Click Use a specific user name and password for step 2.
      1. The User name is typically SA with the password for your SQL Server.  The Acctivate support team can assist if you do not know your password.
    4. Check the Allow saving password option
    5. Choose your database from the Select the database on the server drop-down
    6. Click Test Connection.  You should see a Test connection succeeded message
    7. Click OK to return to the ShipRush Contact Manager settings
  6. Copy and Paste the SQL script for selecting records from Acctivate (see below) into the SELECT Query box
  7. Check the Show Search Dialog box
  8. Optionally select the Use USB Barcode Scanner box if you have a scanner and would like to scan the barcode from the Sales Order or Shipment documents.
  9. Check the Reopen after shipment processing box.
  10. Select the Writing History Info tab
  11. Repeat step 5 (above) to set up the database connection for writing shipment/tracking information back to Acctivate
  12. Copy and Paste the SQL script for writing records to Acctivate (see below) into the SQL Script box
  13. Click OK to save the settings

SQL Script for Selecting Sales Order records to ship:

SELECT
o.OrderNumber AS RecordID,
COALESCE(NULLIF(o.CompanyName, ''),NULLIF(o.CustomerID, '')) AS CompanyName,
COALESCE(NULLIF(o.ShipToAttn,''),NULLIF(o.ContactName,'')) AS ContactName,
o.ShipToAddress2 AS Address1,
o.ShipToAddress3 AS Address2,
o.ShipToAddress4 AS Address3,
o.ShipToCity AS City,
o.ShipToState AS State,
o.ShipToZip AS ZIP,
o.ShipToCountry AS Country,
o.ContactPhoneNumber AS Phone,
o.ContactEmailAddress AS EMail,
o.Reference AS Reference,
o.CarrierService AS Service
FROM OrdersAvailableToShip AS o
WHERE o.OrderNumber LIKE '%SEARCHPARAM%%'

NOTE: ShipToAddress2, ShipToAddress3 and ShipToAddress4 may need to be shifted based on the address block style you’re using in Acctivate and QuickBooks

  • Be sure to select the option to clear prior search history upon import.

SQL Script to Write History Info back to Acctivate

INSERT INTO tbOrderPackagesText (
CarrierService, BillingOption, OrderNumber,
ShippingCharge, TrackingNumber, Weight, ShipmentDate)
VALUES ('%ShippingService%', 'Prepaid', '%RecordID%',
%ShippingCharges%, '%TrackingNumber%', %ShippingWeight%, GETDATE())

NOTE: The above SQL Scripts are for shipping Sales Orders.  You will need a different set of SQL scripts for Selecting Package Manager shipments.  Please contact our support team to discuss options for integrating with Package Manager.

Posted in Installation, Shipping - Last modified on November 11, 2016Brad Bearden
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support request.