Exporting Orders
TechCart 2.xx has the capability to exportyour orders for use in another application such as spreadsheets like Microsoft Excel ordatabases like Microsoft Access. To access this feature you will need to first loginto the administration area. From there select SETUP andthen EXPORT ORDERS.
The screen that you should arrive to should look similar to the following:
The standard installation of TechCart comes with only one EXPORT TYPE, however you mayhave additional types depending on the installed modules. Please refer to thedocumentation for each additional export module you have installed for more information.
To export your orders you will need to specify three items. They are
EXPORT TYPE
BATCH # to Export
OUTPUT FILENAME or Filename to Export
EXPORT TYPE
Standard installations will only have one option here. This is Standard Export(Comma Delimited). If you have additional options installed please refer to eachindividual export modules' documentation.
BATCH # TO EXPORT
Here you will specify which batch of orders you wish to export. You can leave this blank to export the current batch of orders.
Specify Batch Number To ExportHere
OUTPUT FILENAME
Here you will specify which the filename you wish to export these orders to. TechCart will automatically offer a default name based on the current date. If thefile specified already exists, TechCart will append to this file.
Specify Filename To Export IntoHere
In most cases the defaults will suite yourneeds. Once all of your export options are set you simply press the EXPORT ORDERSbutton and retrieve the order file later via telnet or FTP.
STANDARD EXPORT FILE FORMAT
The default export option is STANDARD EXPORT. This fileis a CSV file or comma delimited file that can easily be exported into most spreadsheetsor database programs. The file is formatted one order per line with up to five items onthe invoice. If the order contains more than 5 items a new record is created.
| Field Number | Description |
| 1 | Order Date |
| 2 | Order Number |
| 3 | Billing Last Name |
| 4 | Billing First Name |
| 5 | Billing Address 1 |
| 6 | Billing Address 2 |
| 7 | Billing City |
| 8 | Billing State |
| 9 | Billing Zip |
| 10 | Billing Country |
| 11 | Billing Telephone |
| 12 | Billing Method |
| 13 | Card Number |
| 14 | Card Expiration |
| 15 | Shipping Type |
| 16 | Item PID |
| 17 | Item Quantity |
| 18 | Item Description |
| 19 | Item Price |
| 20 | Item PID |
| 21 | Item Quantity |
| 22 | Item Description |
| 23 | Item Price |
| 24 | Item PID |
| 25 | Item Quantity |
| 26 | Item Description |
| 27 | Item Price |
| 28 | Item PID |
| 29 | Item Quantity |
| 30 | Item Description |
| 31 | Item Price |
| 32 | Item PID |
| 33 | Item Quantity |
| 34 | Item Description |
| 35 | Item Price |
| 36 | Ship To Last Name |
| 37 | Ship To First Name |
| 38 | Ship To Address 1 |
| 39 | Ship To Address 2 |
| 40 | Ship To City |
| 41 | Ship To State |
| 42 | Ship To Zip |
| 43 | Ship To Country |
| 44 | NOT USED (repeat of Pay Method) |
| 45 | Shipping Costs |
| 46 | Customer Email Address |