This page is a walk through to set up Descartes ShipRush with the Northwind database on SQL Server or MSDE 2000.

Note: This file references our example kit, found here.

Lets get started:

1. Create a new database in the SQL Server and name it NorthwindCS.

2. Unzip the example kit, and locate the file "NorthwindCS.SQL".

3. Log into SQL Server (with Query Analyzer or equivalent) and change to the NorthwindCS database.

4. Run the "NorthwindCS.SQL" script in the database to create the database and populate the system with data.

5. Install or launch the Desktop Toolbox if not already running.

6. Navigate to the Webstore Settings area for your SQL Webstore and click Edit.

7. Fill in your "Select" and "Update" SQL strings and click Save.

8. Use your Barcode Scanner, or launch the search box from the Desktop Toolbox, to find an order.

9. Process the Shipment in Descartes ShipRush.

SQL Code Discussion

Here is the Get Data Query:

SELECT

o.OrderID as RecordID,

o.ShipName as ContactName,

c.CompanyName as CompanyName,

o.ShipAddress as Address1,

o.ShipCity as City,

o.ShipRegion as State,

o.ShipPostalCode as ZIP,

o.ShipCountry as Country,

c.Phone as Phone

FROM dbo.orders o

LEFT OUTER JOIN dbo.Customers c ON c.CustomerID = o.CustomerID

WHERE o.OrderID LIKE '%SEARCHPARAM%%'

And here is the Write History Query:

update dbo.Orders set Freight = %SHIPPINGCHARGES% where OrderID = %RecordID%

Next: SQL Webstore - Fields Reference

Back to Top