How do I connect Acctivate to ShipRush?

If you want to integrate with ShipRush, take these steps.

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.

Acctivate can be integrated with ShipRush Web or ShipRush Desktop (SQL Edition). Instructions for both editions can be found below.

ShipRush Web

The following instructions will guide you through the integration with ShipRush Web.

  1. Login to your ShipRush Web account.
  2. In the left menu, choose Settings.
  3. Choose Add Web Store under the Web Store section of the left menu.
  4. On the Add Web Store: Select Platform page, select SQL and click Next.
  5. You will be prompted to download and install ShipRush Toollbox  on the computer where your Acctivate SQL Database resides, typically this is your server. If you already have ShipRush Toolbox installed you do not need to re-install it. After installing, login to ShipRush Toolbox using your ShipRush credentials, then click I have my connection string!.
  6. On the Add SQL Web Store page, fill out the following fields:
    1. Web Store Name: Acctivate
    2. Workstation: Select the PC name of the workstation that both your SQL database is on, and has the ShipRush Desktop Toolbox.
    3. Connection Type: OleDb
    4. Connection String: The connection string will have the following format:
      Provider=sqloledb;Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

      Where myServerAddress = The SQL Server, myDatabase = your  Acctivate database name, Id = sa, Password = The SQL Server password for the sa user (contact support if you do not know this). An example string would be:

      Provider=sqloledb;Data Source=Server\Acctivate;Initial Catalog=Acctivate$Demo;User Id=sa;Password=ABC123; 
    5. Select SQL:
      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.OrderNumber AS Reference,

      o.CarrierService AS Service

      FROM OrdersAvailableToShip AS o

      WHERE o.OrderNumber LIKE '%SEARCHPARAM%%'
    6. Update SQL:
      INSERT INTO tbOrderPackagesText (

      CarrierService, BillingOption, OrderNumber,

      ShippingCharge, TrackingNumber, Weight, ShipmentDate)

      VALUES ('%ShippingService%', 'Prepaid', '%RecordID%',

      '%ShippingCharges%', '%TrackingNumber%', %ShippingWeight%, GETDATE())
  7. Click Continue.
  8. In the ShipRush Web interface, expand the Ready to Ship category on the left and click  Acctivate beneath it. Enter an Acctivate sales order number in the search bar and type or scan the Acctivate order number to open the order. 

ShipRush Desktop (SQL Edition)

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.