Mailware - Mail Order Software

support | tech support | custom services | online tutorials | training

mailware queries
Mailware Queries are special programs that run from the Tools text
menu. They can be used to import data, change all your product
prices, import shipping tracking numbers, create a mailing
campaign and much more.

You can create your own queries if you know QBE and SQL or have us create them for you. Following are instructions for writing your own queries. You can also simply browse through the instructions to get an idea of what queries can do. Several sample queries are included in the download (they are described below).

If you would like us to create a Mailware Query for you please contact us.

You will need the following query tool and sample queries.
Click here to download the Query Tool and Samples

The download above contains several sample queries you can examine, edit and use. Anyone can install and use the samples, however it is strongly recommended you install them to your Sample Data Directory and test them there. When prompted for the Data Directory (not the install directory) select your Sample Data Directory folder (usually c:\mailw15\sampdata - see Locating your Data Directory in our Tips page).

After installing the query tool, open Mailware. Click the Tools text menu item. The bottom portion of the menu will contain a list of available queries. You can run a query by simply selecting it, however some queries require you create a text file first (e.g., ImportTrackingNumbers.mwq).

We recommend you try the Create Rental Table query first. This will create a Rental.db table in your data directory that contains your customer information. It is a safe one to run because it does not affect any of your data. However, it may take a while if you have a very large customer list.

The queries that will be installed are:

CleanItems.mwq - Deletes orders with blank order numbers.
ClearTracking.mwq - Empties the Tracking.db table. This deletes ALL tracking information for ALL ORDERS.
Create Rental Table.mwq - Creates a Rental.db table of names from your customer database to rent to other companies. Note: Rental.db includes credit card information.
FixImportedPhones.mwq - Formats phone numbers to include dashes (123-123-1234)
ImportTrackingNumbers.mwq - Imports tracking numbers from a file created from your shipping software. The file must be in comma delimited format and must contain the Mailware order number and the tracking number (e.g., "10", "123" imports tracking number 123 into order number 10). Name the file "TrackingNumbers.txt" and place it in your data directory.
Markship.mwq - For versions of Mailware prior to 1.7 that are upgrading to 1.7 or higher - Marks all items in all orders as Shipped.
Paid.mwq - Calculates the total order amount and enters it into the paid amount field on the Order screen Payment tab. This is useful for imports that do not include the paid information (e.g., the Yahoo-MOM import from Yahoo Stores).
SalesTaxReporting.mwq - Creates the table SALESTAXREPORTING.DBF which lists all orders, their taxable amounts and sales tax collected.

Advanced Users
To create your own queries you need to know QBE (Query By Example) and SQL query languages. If not, you can order queries through our custom programming service.

Following are the commands you can use in a Mailware Query and a sample query. Items in [ ] are typed without the brackets. You can also open the installed queries with Notepad to review them.

Mailware Web - eCommerce software

Mailware - mail order software