Advanced Connectivity Tools for Connecting to Your Data!
easier, faster, and with fewer errors using its advanced
connectivity tools. The External Link
“tool box” in CPS provides easy connectivity to your existing
data, whether you ship one package at a time or many
packages at once in a batch. CPS can automate the entire shipping
process and even has "hands-off", totally automatic shipping!
Whether accessing a company
database, an accounting program on a networked PC, or shopping
cart order files from an ecommerce system, CPS increases parcel
velocity through your business and lowers operating costs. CPS
connectivity tools combine with CPS features, such as
Default/Skip Schemes, to eliminate keystrokes when you ship.
pioneered a number of ways for shipping systems to use existing
data. Special data translation tools for ODBC compliant tables,
special features for SQL data, transparent data importing and even
a real “hands-off” processing mode. Every situation can be
different and CPS has the tools to help.
Special Note: CPS comes with very flexible, advanced tools to
connect to your data. We try our best to back up all of our
connectivity tools with easy-to-use interfaces and on-line help. Many
of our clients say linking to company data is easy with CPS, but others
need help due to special requirements. In this case we give you
choices. One solution is to use one of our
If you do not find a Ready-Made Solution that fits your needs and you
are unsure if your company has the needed technical resources, contact
Harvey Software Business Partners are experts in getting your data
connected to CPS. If you still do not find solutions,
with your needs.
Fast Parcel Processing Solves Your Shipping Problems...
ODBC and External Link - Real
Time Connection to Your Data
ODBC (Open Data Base Connectivity)
in CPS is a smooth, reliable real-time link to your shipping
data. Just enter the order or consignee ID and CPS collects the
shipping data in "real time" from your in-house systems. After
the parcel is processed, CPS can also send the shipping
information back to your linked system. The external data can
be located on just about any type of system, from mainframes to
client server systems to stand-alone databases on your shipping
computer. All that is needed is a Level 2 compliant ODBC driver
and your system is ready for streamlined shipping! ODBC support
is included with every CPS package.
With ODBC and External Link you can:
Collect data from a single table
Collect data from a second table
looked up from a link in the first table
Collect data to a SQL Stored
Procedure1 on your SQL Server
Translate data coming from and
going to your table
Write shipping data collected back
to your table
Update a record on write back to
Write back changes to already
Write back deleted parcel
Auto-process separate first and
last name fields
Include time stamps with write back
ODBC Setup is fast. You just choose
your data table and match your data fields to CPS through an
easy to use graphical interface. Once this is set up, it only
needs to be changed if your data table changes. Data entry for
your shipping department becomes a snap.
Click to Enlarge
Sample External Link Set up Screen
ODBC is one an excellent way to link
your in-house data to CPS. Using ODBC helps lower system
maintenance and upgrade costs as your other software systems
change over time.
To learn more about why you should consider
ODBC, read the article from DataDirect Technologies2 web
site entitled "PRODUCT
OVERVIEW - Why developers should use ODBC instead of native proprietary
1 Stored procedures are small
stand-alone programs or routines written (usually) in SQL (Standard
Query Language) and stored in a database for easy retrieval by other
programs or procedures. A stored procedure contains a set of operations
or queries to execute on a database server. Stored procedures should
only be used if your database query is more complicated than a one or
two table look-up. The stored procedure does require programming and
maintenance on your part.
2 The article entitled "PRODUCT
OVERVIEW - Why developers should use ODBC instead of native proprietary
database interfaces" is a the property of DataDirect Technologies
(http://www.datadirect-technologies.com). © 2002 DataDirect
Technologies, Inc. All rights reserved. DataDirect Connect is a
registered trademark of DataDirect Technologies. Harvey Software is
using this article by permission. This article is provided for
information only. Harvey Software does not endorse the content or
accuracy of this article and/or claim that any of DataDirect
Technologies products will work with your data bases and/or CPS.
DataDirect Technologies offers a Wire Protocol ODBC driver for every
major database - Oracle, DB2, SQL Server, Sybase and Informix. (http://www.datadirect-technologies.com/products/odbc/odbcindex.asp)
The successful use of DataDirect Technologies products with CPS will be
- Add Packages as You Work
Background Importing and Exporting
moves data to and from an external data source automatically.
The shipping system operator just continues to process parcels.
Imported data is ready to be used immediately, and exporting is
so fast it is invisible to the shipping system operator.
Background Importing and Exporting is very versatile, extremely
stable, works in a multitude of environments and is easy to set
up. Background Importing and Exporting uses easy to work with
text files, and you can adjust CPS to use the data in your file.
No additional user steps needed to
import or export data
Keeps your shipping data in a
"holding" file until you are ready to use it
Included with every CPS package
Automator - Hands-Free Shipping
With the CPS Automator, shipping
becomes a hands-free operation. The Automator imports and
processes package data, prints shipping labels and
documentation, then exports data about the shipment - all
without any intervention. Shipping becomes a hands-off
process! This works especially well in areas where security or
user errors are of the utmost concern.
If you are interested in The Automator,
please contact one of our shipping software specialists. They will
be glad to give you the necessary requirements to make this method work
for you. This option is available in every CPS package.
Send data directly from your order
or other system to CPS
Handles International parcels and
commercial invoice items
Extremely fast package processing
Supports auto-processing of
separate first and last name fields
Batch Importing/Exporting - Add Packages by the File
If your shipping data is in a CPS
supported text file format, you can import this directly into
CPS. Batch Importing and Exporting is one of the oldest
and is still a popular way to send data to CPS. You can adjust CPS
to use the data in your text data file.
Batch Importing is used to import the
CPS Customer Master File
Commercial Invoice Product File
Supports comma delimited (TXT, CSV) and fixed
field file formats along with XML, spreadsheet and other files
converted to CSV files
And for Yahoo! stores, eBay sellers and Amazon
merchants, batch importing is the perfect tool to easily ship
orders using the text order file each provides. Import the data
and you're ready to ship!
Include all the shipping information
(like the weight and method of shipping) in the data you import
into the CPS daily entry data base and CPS can automatically
process the data and print out all the required labels without
any extra steps in-between. Hundreds of thousands of parcels
are processed through CPS in just this fashion every day.
In addition, all the data stored in
CPS can be exported with pricing and shipping information just
as easily as it can be imported for processing. Batch Importing/Exporting is available in every CPS package.
Cut'N Ship® - Google
Checkout and Order Shipping
Cut'N Ship is one of the easiest ways to
link CPS to an order entry system. If you can highlight the address
text, copy it to the clipboard and paste it to Notepad, you can use
Cut'N Ship regardless of any non-shipping related data you collect. Cut'N
Ship adapts to varying address formats and works with multiple online
merchant account sources simultaneously.
Cut'N Ship comes already set up to process
Google Checkout™ Buy Now buttons and HTML API orders using the Google
Checkout merchant order information page. Cut'N Ship is a very powerful
tool and is included in all versions of CPS.
With just a few easy-to-follow steps, you
Extract "Ship To" information from
the online system
Choose the best way to ship -
manually or automatically
Clean up and correct address
Add weight, extra services and
Print required labels and
Return tracking information to the
Stores shipping information for
future tracking and reference
Use order numbers for reference
Send shipment notifications
Google Checkout™ is a trademark of Google. All
rights reserved. Use of the Google Checkout trademark does not mean or imply
there is a relationship or affiliation with, sponsorship, or endorsement by
Google of Harvey Software or its products. Harvey Software, Inc and Google are
separate companies. The use of Google's trademarks are for instructive purposes
only. Google Checkout helps you attract new customers, convert more sales and
lower transaction processing costs. Google Checkout™ is a checkout process that
you provide on your website to enable your customers to buy from you quickly and
securely, using a single username and password. And once they make a purchase,
you can use Checkout to charge their credit cards, process their orders, and
receive payment in your bank account.
Solutions - Out-of-the-Box Solutions
(Prices and CPS Package Requirements
To make life easier, many companies
find the power of CPS a great addition to their existing
products. Interfaces have been created with Harvey Software's
cooperation and partnership with other companies and these are
purchased directly from Harvey Software Business Partners.
Harvey Software Business Partners
are a group of software companies that install, set up and
support CPS interfaced to their business software and hardware
solutions. These companies supply all that is necessary to have
a seamless solution from consulting to the final solution.
Their scope is much larger than that of just the shipping
component as they often offer entire turnkey business solutions.
Due to the complexity of these
specialized applications, Harvey Software Business Partners
become the first line of support, and are then backed up by
Harvey Software's Technical Support staff whenever needed.
To learn more about Harvey Software Business
Partners click here.
– provide solutions for mail order, retail,
manufacturing, shopping cart, ecommerce system or other
applications using Harvey Software products for their shipping
solution. Integrated Partners are trained to resell and support
Harvey Software's supply chain tools.
- business consultants, systems integrators
and carrier service providers that provide enhanced services,
and can sell, install, support and train shippers in the use of
Harvey Software products.
Shipping Software Connects to Intuit QuickBooks
Do you use QuickBooks? Our CPS
shipping software integrates to read from and write to Intuit’s
QuickBooks Accounting Software. Take advantage of this powerful
integration feature to:
Read order data from QuickBooks to
CPS for shipping packages
Write tracking numbers and shipping costs for each order
from CPS to QuickBooks
Reduce shipping department data
errors in the accounting system
Speed up your shipping process
ATTENTION ALL QUICKBOOKS USERS
Connect to CPS for
It’s this simple
Purchase or renew a CPS annual
license, download the QODBC Desktop Edition Read/Write Driver and
receive a credit for the full cost of the driver.
Call us today at 1-800-231-0296 or
click here for a quote.
This offer expires 12/31/12, so act
now to streamline your shipping and accounting departments!
Not using a multi-carrier shipping
system yet? Check the many benefits of using our CPS shipping software
at our Products Page and
Software Parcel Shipping Blog. Here are some specific ways
connecting QuickBooks to CPS will help your business.
No more time wasted manually
entering shipping data. Connect QuickBooks to CPS and eliminate
the risks of manual entry with virtually error-free data and
faster shipping of orders. To ship a package, just enter the
customer reference number (your QuickBooks Sales Order Number or
Invoice Number), then CPS retrieves the shipping
information and finishes the shipping steps, ensuring that each
shipment is optimized according to your business rules. The
result is a more efficient, automated process and lower shipping
costs. What could be better?
No manual entry required! After a
package ships, the shipping cost and package tracking number
write back from CPS to QuickBooks. This happens instantly with
little risk for error. The accounting department knows in REAL
TIME what’s going on in shipping.
Plus, when it comes time to
reconcile a carrier invoice, shipping information can be
accessed via CPS monthly shipping reports so a CPS/QuickBooks
user will be able to reconcile each carrier’s statements
Shipping information exported from
CPS can be inserted into QuickBooks invoices. Your customer can
see tracking info and shipping charges directly on their
invoice. By providing complete info in one document, you
consolidate your business’s communication with your customer
into one simple, complete statement.
Sometimes, new CPS users didn’t even
know their shipping process was inefficient, discovering after
only a brief time using CPS they find they spend less time with
shipping and more time improving other parts of their business.
With the new connection available between QuickBooks and CPS,
your business can see these improvements immediately.
Your current shipping process
involves typing an address into a shipping system, taking time and
inviting potential human error.
Use QODBC to connect CPS to
QuickBooks to eliminate errors and speed up package processing!
Your accounting process involves
taking paper shipping reports and entering them into an accounting
CPS sends shipping data directly to
QuickBooks (or any other accounting program), saving paper and
your employees’ time!
You now send out multiple emails for
every order: one for order confirmation, another for shipment, and
another for tracking. Your customer’s email box is flooded from
one simple order.
Export CPS shipping data instantly
back to QuickBooks, allowing your customer invoice to have
shipping and tracking info on the original invoice.
You receive carrier shipping
invoices that are completely different from expectations and don’t
match your accounting records.
CPS shipping software reports
carrier rates and checks commercial/residential address status for
every package, ensuring accurate rate reporting and carrier
New to QuickBooks?
Fast Parcel Processing Solves Your Shipping Problems...