2011-02-17

Add a new customer to your database, or change an existing one.

Quick Jump to:

Search for a Customer

Add a Customer without Searching

Additional Info Tab

Special Pricing Tab

Orders Tab

Contact Log Tab

Attachments Tab

Instructions

Search for an existing customer account before adding a new account. Or, find a customer to edit and enter additional information and contacts.

Searching for Existing Customers

If you would like to search for an existing account to edit or before adding: Click the Find Customer button in the Customers icon on the Main screen of the Mailware Explorer,  you can also press the F4 function key . This opens the Customer Search screen.

Enter as many fields as you need to locate the customer then click the button or press Enter.

If your search located the customer: Matches will appear in the lower half of the screen. Highlight the record you wish to open and either double click it, press Enter or click the OK button.

If your search did not locate the customer: Click the button, or press Alt-A to add this customer now. The customer screen will open with the search fields you typed already entered. Tab or Enter through each field to enter the remaining customer information.

Adding a Customer

Click on the Customer Icon in the Main Menu in the Mailware Explorer.

This will open the Customer screen.

To add a new customer click on the button.  The customer screen will open to a blank account and you can begin entering data.

Enter the customers contact information (name, Address etc.)  Use the Tab or Enter key to move between fields and the space bar to press buttons. Depending on your Preference settings fields will automatically capitalize first letters. You can change this setting in Preferences under the Data Entry tab.

If the customer shipping address is the same as their billing address, click on the button.  This will copy all of the billing address information into the corresponding shipping address fields.

Customers with multiple shipping addresses are handled in the order screen where you can change the default shipping address and, with the use of the lookup button, you can look up all of the previous addresses used by the customer.  For more details click here.

The check box is used with shipping integrations to pass this information to them.  Note: If you are an existing Mailware user that has a shipping integration(s), this field will have to be added to the field mapping for your shipping integration(s).

Enter Phone numbers with the number pad on your keyboard. You do not need to enter the dashes (-) for U.S., Guam, Puerto Rico and Canada. They will be automatically added. However, if you cut and paste a phone number you will need to manually enter any missing dashes. Enter an email address in the above field.  To send an email to this customer click the button. A blank message will open in your default email program.  Enter in the customers web site in the above field, click on the icon to open the web page in your default web browser.

Additional Info

Additional customer information includes pricing levels, a short note, system flags and system IDs.

Click on the tab .

This will open the following screen.

Below is a description of the fields  in the Additional Info area of the Additional Info tab.

Price Level-This will default to the price level that is defined in Tools->Preferences under the Orders tab.  Setting the price level for the customer in this screen (either Retail, Wholesale, Price3 or Price4) will determine which of the prices will be used when this customer submits an order.

NOTE: If the customer is set to a price level of Wholesale and there is no Wholesale price information in the products table, the price will default to the Retail price level.

Discount-This will set the discount for each order that the customer orders.

Store Credit- This field is used by the software to track store credit.  If the customer returns a product, the amount of the return can be applied to this field.  To use the store credit for a future purchase, select the Balance from the Method drop down menu.

You can manually adjust the Store Credit by clicking on the button.  This will open a dialog box similar to

Type 1 to Type 4-These fields can be used to set up to four customer types for each field.  The customer types can be set up from the Setup screen.

From the setup menu select Customer Types…

This will open up the Customer Types dialog.

To assign the customer type to a field do the following:

Enter the value you want to show in the drop down in the Customer Type field.

Enter in “True” in the column that  you want the value to show up in (IsType1, IsType2 etc).

Enter in “False” in the remaining three columns.

Repeat the process for each type.

When done your dialog will look something similar to below.

In this example Type 1 will show the options of Male and Female

Type2 will show the age ranges.

When done setting up the Customer Types click on the button.

The customer types will show up in the screen as shown here

Pay Method-Use this option to select the default payment method for this customer.  The options are: Credit,Check,Cash,COD, PO, Bill, Invoice, Install, Direct Dep, and Money Ordr.   The default option can be overwritten in the Payment dialog box.

Terms-You can set the terms in this dialog box.  The options are Due Upon Receipt and Net 30

Sales Rep-Use this option to assign a Sales Rep.  You can select an Operator ID from the drop down and assign them to the customers account.

Note- You can type in a note into this field and it will show up in the order message field in the order screen.

Popup Note-If you enter in a note in this field a note will show up as a popup when the customer is selected.

Pin- This field can be used for requiring a customer to enter a pin number before they can place an order.

Pin Hint-This is the field that stores a hint for the pin number.

Date of Birth-This field can be used to send out notices or special offers for  customers with a birthday.

Primary SIC-This field is used for storing the primary Standard Industry Classification (SIC) code.

Secondary SIC- This field is used for storing the secondary SIC code.

Corporate Client Number-This field is used for storing a unique number associated with a specific corporate client.

The System Flags area of the Additional Info tab is where you set specific flags for the customer.

Customer is Tax Exempt-Checking this box marks this customer as Tax Exempt and no taxes will be charged when this customer places an order

Tax ID #-This field is used for storing the Tax ID number if the customer is Tax Exempt.  This field is used for reporting any sales that are tax exempt.

Don’t Send Mail-This flag is used in conjunction with the report writer to prevent this customer from their name being added to a list of customers receiving mass mailings.

Don’t Send Email-This flag prevents this customer from receiving Email notifications from the system.

Don’t Send Fax-This field is used in conjunction with the report writer will prevent this customer from receiving faxes from the system.

Bad Credit- When this option is checked, it does not prevent orders from being taken for the customer.  What it does do is put a notice in the Order Info tab on the order screen.

Inactive Account- Checking this option does not prevent the customer from placing an order.  What it does do is put a notice in the Order Info tab on the order screen.

Mailware automatically assigns fields in the System Information section based on the data you enter and your Preference settings.You can also manually change fields by clicking the button. Fields will open for editing and remain open (white) until you close the Customer screen so you can edit multiple accounts if you wish.

Alt Customer #-This is an Alternate Customer Number made up of elements of the customer’s data (name, address etc.). It can be used in place of the System ID # in reports. You can edit the customer number formula in Preferences under the Customers tab.

Customer Type-This field indicates the status of a customer.

Mailing – The customer has never contacted you. Typically this is used when you are sending a mailing or email to a prospect. Mailware does not automatically set this type. This status is usually imported with a group of new customers.

Inquiry – This customer has requested something from you (a catalog, free information etc.), but has never purchased. Mailware automatically sets this status when you add a new customer manually.

Ordering – This customer has placed an order. Mailware sets this status when an order is entered for a customer.

Original Key – You can assign Advertising Source Keys to orders and contacts. The first key assigned to a customer is the original key. It helps you determine which ads have attracted customers.

System ID/Customer #-This is a unique, system assigned sequential number. It is also the key field for the Customer table, and cannot be changed  (Table.Field: Customer.CustNo).

Add Dt – This is the date you added the customer’s account to your database.

Special Pricing

You can override prices for individual items and groups of items for selected customers. The prices, discounts, quantity discounts and price levels you enter on this tab will take precedence over any other amounts for this customer.

Click on the tab

To add a special price for a customer, click the button on the lower toolbar.

In the blank line that appears you can enter a product number or click the button to search for a Product Number.  You can simply enter a single product number, or use one of multiple methods to select a range of products.

For a range of consecutive product numbers enter the beginning number in the From Product field and the ending number in the To Product field.

For similar numbers you can use either of the wildcards: % or _ (underline). The % symbol substitutes for any number of characters. The _ substitutes for a single character.

For example, you could select both the BB-00001 and BB-00002 products from the sample database with the _ as follows: or, with the % .  In both examples you do not need to enter a “To Product” value.

Min Qty – Use this field to enter the minimum number of the selected item or items that must be purchased to receive the price in the Price field. Use multiple lines of the same item to enter multiple quantity discounts.

In the example below BB-00001 has a price of $19.99 when 1 to 4 are purchased.  At a quantity of 5 the price reduces to $15.99.  At 9 or more the price is $12.99. Note that BB-00001 is included in this quantity discount matrix because it shares the Mix & Match code BB. Note too that although it contributes to the total count to qualify for a discount its price will always be the $21.99 amount entered on the grid (e.g., If 3 BB-00001 and 2 BB-0002 products are purchased the price for the BB-00001 products will be $15.99 each and for BB-00002 will be $21.99 each).

Note: If you do not enter a Min Qty for a product that already has a Quantity Discount set up on the Product screen, then the existing Quantity Discount will apply.  You can, for example, change the Price Level in special pricing and the associated Quantity Discount will apply.

Mix & Match – Use this field to allow products to share quantity discounts. Each product or product range that contains the same text here will share the quantity discounts you set in the Min Qty and Price fields. You may enter any text you wish in this field. (see sample below in Min Qty).

Price Level - Select a level from the pulldown to apply that level’s price. For example, if a customer has a default price level of Retail you can select Wholesale from the pulldown to apply wholesale prices to the selected products.

Note: You may select a Discount % and Price Level for a product. This will apply the % discount to the selected level (e.g., Wholesale less 10%).

Start Dt and End Dt - You can enter an effective date range for each special price. Click the field and enter a date or click the  button that appears to select from a calendar. Orders entered outside of the date range will receive the regular price for the items.

Note: The date used for determination is the Order Date at the time the item is entered. If an item has a sale date of 1/1/11 to 1/31/11 and the order date is 1/15/11 the discount will be used when the item is added to the order, even if you edit an old order later to add a new item. Existing items, however, will not recalculate unless you edit them (e.g., change their quantity).

Discount % – Enter a percent discount to be deducted from the price normally charged to the customer (based on their Price Level – Retail, Wholesale etc.).

You can enter items in any order you wish. Mailware will sort them and apply discounts accordingly. After you have entered the items you wish to discount you can take a new order to see the discounts apply. Please note that changes to the special pricing grid will not affect a currently open order. To use new discounts, close and reopen the order and enter your items.

Order History

Each order for a customer is displayed in the Orders tab. You can open any order to view or edit it.

When adding a customer, no history will exist until you enter an order for the customer. You can do so by clicking the button. See the Take an Order help topic for assistance with entering an order.

When viewing an existing customer, you can click on the tab to see all orders associated with that customer.

The customers order history will be displayed in the following grid.

In the grid you can click the button next to any order to see the items in the order. You can also filter fields by clicking the button next to the field name, and group by dragging a field into the blue area above the grid.

For more details on an individual order, click it then click the button or simply double-click the order. The Order screen will open, and you can view it or make changes. For detailed help on orders see the Orders help topic.

Contact Log

Use the Customer Contact Log to keep records of phone calls, mailings etc. You can also use it to perform special tasks in Mailware like sending catalogs and setting Ticklers (reminders).

Click the tab.

Any existing contact will be displayed in the Contact Log grid.

You can select any contact and then click the to view it, or simply double-click it. A dialog will open with the details of the contact.

To add a new contact, click the button. Note: When entering a new order or contact any advertising source key you enter will automatically be assigned to the customer’s Original Key on the Additional Info screen if one does not already exist.

Source Key – You can select an Ad Source Key in the first pulldown if applicable (e.g., a customer called requesting a catalog seen in one of your ads). You can set up keys so they can be selected here by selecting the Ad Source Key table in the Mailware Explorer.

Action – Select an appropriate item from the pulldown list. (Tip: You can select an item in the list by typing the beginning of its name. You can also  enter anything you wish by simply typing it and pressing the Tab key).  To set up the customer contact actions, follow the instructions below:

Click on the Setup menu in the Customer dialog and select the Customer Contact Actions… option.

The following dialog will open.

To add a new action click on the Add button.  This will add a new row to the dialog and key in the action that you will want to add.

Notes -This  field length is unlimited and appears on internal use reports.

Tickle Dt – Enter a date in this field in the format mm/dd/yy. This field is used by the R3180 Ticklers for Date Range report to remind you to perform the Action you selected above.

Days – This field is used by certain Mailware Queries to calculate the number of days between events. If you are not using one of these queries you can leave this field blank.

Operator - If it is not automatically entered for you, select your ID from the pull down list or type your ID number and press the Tab key.

Note: The Operator is automatically assigned if the security feature is Activated.  Click the Operators & Security help for more information.

After entering all data, click on the button.

Attachments

Use this tab to attach documents to a customers account.  This is useful for linking signed legal documents or statements of work to a customer record.

Click on the tab.

The following dialog will open.

To add a new attached file or image press on the  button in the grid toolbar.  This will add another record to the grid.

Tab through the fields to add information to the grid.

File Name- This is the file name of the file/image you are attaching.  This is automatically populated when the file is attached.

Description- This is an optional description of the item that you are attaching.

Type- Select the type of file you are attaching from the drop down list, the choices are File or Picture

Add File…- Click on the  icon in the field this will open up a file dialog in the default directory similar to

Select the file you want to attach and click on the Open button.  When you have successfully attached a file your screen will look similar to

You can click on the  button to view the file in its associated application.

To add images the process is the same except you select Picture from the Type field and click on the  field in the Add Picture … field.  This will open the file dialog box with a filter for images.

Click on the Open button and your attachment screen will look similar to

UNDER THE HOOD: The Customer table interacts with the CustPrice, CustServ, CustomerAttachments, CustomerType and the Orders tables.  When a new customer is added to the system either through the Orders screen or by clicking the New button in the Customers screen, a blank record is added to the Customer table the CustNo in the NextCust table is incremented by one and this value is added to the CustNo field.  The default price level (as set in the Customer tab in Tools->Preferences) is assigned to the LastPayMeth field (R for retail,W for wholesale, 3 for Price3 and 4 for Price4).  If any of the customer types are assigned to the customer, the values from the CustomerType table are added to the corresponding Type1 through Type4 fields in the Customer table.

Customer type setup is stored in the CustomerType table.  The customer type values that show up in the Type 1 through 4 drop down boxes are stored in the CustomerType field.  The IsType1 through IsType4 boolean fields determine which drop down the values in the CustomeType field will appear.  When a IsType field is set to True the CustomerType value in that row will appear in the corresponding type field in the Additional Info tab.

Special pricing is stored in the CustPrice table.  When a new record is added to the Special Pricing tab, the CustNo field is populated with the corresponding value in the Customer table, the CustPriceNo is an autoincrementing primary key,  the ProductNo and EndProductNo fields are populated from the Product table and the remaining fields are populated from the user interface under the Special Pricing tab in the Customer screen.  When an order is taken for a customer with special pricing, the pricing is computed based on the rules stored in the CustPrice table.

When a new contact is added for a customer the following data are added to the CustServ table, the CustNo field is populated from the related Customer table, LogNo field is incremented from the LogNo value in the NextCServ table and the Date field is populated with the system date.  The Key, OperatorID, StatusFlag, TickleDt, Log and TickleDays fields are populated from the Source Key, Operator,  Action, Tickle Dt, Notes, and Days fields respectively in the Customer Service dialog.

If files are attached to a customer the data regarding the attached files are stored in the CustomerAttachments table.  The actual data is stored in the Attachments/Customer folder in the Mailware data folder.  When a file is attached to a customer the CustNo is added to the CustNo field in the CustomerAttachments table, in addition the Description, Type fields are updated from the corresponding fields in the Attachments tab.   After the file is selected the file name is added to the FileName field in the CustomerAttachments table.

Show more