Instructions for Stamps.com Import Back to Total Order Plus Invoice History File

Map V drive on PC to \\192.168.1.2\top_import

Run Stamps.com Export from the TOP O/E Import/Export File Menu to create the STAMPS_COM.csv file

Start Stamps.com if not running

Select <Manage Profile> from the profile pull-down menu  -->  Select New button  -->  Select CVS/Text File (*.csv or *.txt)

Select Next  -->  Enter TOP_SC001 for Profile Name  (001 is for Company 001 in Total Order Plus

Select Next  -->  Select Create a new data source  -->  Select Next  -->  Select Text/CSV File  -->  Select Next

Enter V:\CO001\SC for location  -->  Select Next  -->  Select Next to Confirm Connection

Select STAMPS_COM.csv for Database Table  -->  Select Auto Match button  -->  Select OK for Auto Matching Done

Map the following fields:

Package Tab:

Order ID                ORDER_NUMBER

Order Date            ORDER_DATE

Mailpiece                MAIL_PIECE

Mail Class                MAIL_CLASS

Package Value          PACKAGE_VALUE

Printed Message       PRINT_MESSAGE

Recipient Tab:

Full Name                FULL_NAME

Company                 SHIPTO_COMPANY

Address 1                SHIPTO_ADDRESS1

Address 2                SHIPTO_ADDRESS2

City                        SHIPTO_CITY

State                       SHIPTO_STATE

ZIP/Postal Code        SHIPTO_ZIP

Country                    SHIPTO_COUNTRY

Email                        SHIPTO_EMAIL

Return Address:

Company                    RETURN_COMPANY

Address 1                    RETURN_ADDRESS1

Address 2                    RETURN_ADDRESS2

City                             RETURN_CITY

State                           RETURN_STATE

ZIP\Postal Code            RETURN_ZIP

Select Package Tab  -->  Select Mailpiece button  -->  NOTE:  Import and PostBack use the same table for Mailpiece

Select Maps To pull down menu  -->  Select an option (like Package)  -->  Enter the TOP Ship Via Service Type (i.e. Priority Mail) in New Code field

Select Add  -->  Enter Mailpiece codes and Select Save  -->  Select Mail Class button  -->  NOTE:  Import and PostBack use the same table for Mail Class

Select Maps To pull down menu  -->  Select an option (like Priority Mail)  -->  Enter the TOP Ship Via Service Type (i.e. Priority Mail) in New Code field

Select Add  -->  Enter Mail Class codes and Select Save  -->  Select Next  -->  Select Same data source  -->  Select Next

Map the fields below for Postback Data:

Package Tab:

Order ID                    ORDER_NUMBER

Mail Piece                  POSTBACK_MAIL_PIECE

Mail Class                  POSTBACK_MAIL_CLASS

Mail Date                   POSTBACK_MAIL_DATE

Postage Amount         POSTBACK_TOTAL_COST

Status                        POSTBACK_STAT

Select Mailpiece button  -->  Select Maps To pull down menu  -->  Select an option (like Packages)

Enter the description to display in TOP (i.e. Packages) in the New Code field  -->  Select Add

Enter Mailpiece codes  -->  Select Save

Select Mail Class button  -->  Select Maps To pull down menu  -->  Select an option (like Priority Mail)

Enter the description to display in TOP (i.e. Priority Mail) in the New Code Field  -->  Select Add

Enter Mail Class codes  -->  Select Save  -->  Select Next  -->  Select Done  -->  Select Done

NOTE: To use the interface, select TOP_SC001 profile  -->  Enter TOP order number for Order ID field.