Setup and Field Definitions for Comma Delimited Order (ASCII) File

Index

View Orders Setup for the ASCII file - click here for help

Auto Process Orders Setup for the ASCII file - click here for help

Field Definitions - click here for help

Setup

You can access the ASCII file setup in two ways. First from the View Orders option and second from the Auto Process Orders option. 

View Orders Setup

In the View Orders option select your new orders by clicking the View Orders button.

The list of orders is displayed as follows.

Click the button called Process Selected Orders and the following screen will be displayed:

Depress the Click Here link to view the following screen. To customize the file to your internal system, you can check all the fields that you want sent on the ASCII file. Then click the Submit button and the system will retain your file information until you want it changed. Any time new fields are added for order information they will be automatically added to the file selection list and you may add them using this process. If you do not want them sent on the file you do not have to do anything.

Auto Process Orders Setup

If you do not have the Auto Process Orders option, please call Internet Conduits at 414-727-4033 to activate. This process is used to automatically create a file of orders in real time or batch mode. Click here for setup instructions for Auto Process Orders. To set up the ASCII file depress the Click Here Link. The screen will be the same as above.

Field Definitions

These are the fields that may be passed on the comma delimited ASCII file.  If there are multiple items for an order number, all data associated with the order, e.g. BName, will be repeated for each item. Shipping Cost is the total shipping amount for the entire order and will be repeated for each item on an order. There are three fields that are internal to Internet Conduits, Catalog ID, BillingID and ItemID. These fields may be used to associate and return information about customers and product data (e.g. inventory) to Internet Conduits's database. If you have questions about the fields on this file, please call Internet Conduits at 414-727-4033 or email to support@InternetConduits.com.  

Position on File Field Name Field Name Description Data Type Length Allow Nulls Default Value
1 OrderNum Order Number assigned by system int 4 0 0
2 BillingID Key to associate customer billing info to Internet Conduits's database. May be used to return customer information to Internet Conduits. int 4 0 0
3 OrderPlaced Date Order was placed datetime 8 1 0
4 CatalogID Key to associate the catalog to Internet Conduits's database. May be used to return customer information to Internet Conduits. int 4 0 0
5 BName Billing Name nvarchar 40 0 ('')
6 BAddress1 1st Line of Billing Address nvarchar 40 0 ('')
7 BAddress2 2nd Line of Billing Address nvarchar 40 0 ('')
8 BCity Billing City nvarchar 25 0 ('')
9. BState Billing State nvarchar 40 0 ('')
10 BZip Billing Zip Code nvarchar 15 0 ('')
11 Phone Telephone Number nvarchar 20 0 ('')
12 Fax Fax Number nvarchar 20 0 ('')
13 EMail Email Address nvarchar 60 0 ('')
14 SName Shipping Name nvarchar 40 0 ('')
15 SAddress1 1st Line of Shipping Address nvarchar 40 0 ('')
16 SAddress2 2nd Line of Shipping Address nvarchar 40 0 ('')
17 SCity Shipping City nvarchar 25 0 ('')
18 SState Shipping State nvarchar 40 0 ('')
19 SZip Shipping Zip Code nvarchar 15 0 ('')
20 SpecCustShipping Any special shipping instructions entered by customer ntext 16 0 ('')
21 CheckoutType 'Credit Card', 'Invoice' or 'Information Request' will be passed on the file nvarchar 15 0 ('')
22 Discount Discount amount applied for customer money 8 0 0
23 TotalTax Total Calculated Tax money 8 0 0
24 TotalPrice Total Price of Order money 8 0 0
25 PoNo Purchase Order Number nvarchar 30 0 ('')
26 ShippingCost Total Shipping Cost of Order money 8 0 0
27 ShippingChoice Delivery method if applicable, e.g. UPS Ground.Will also state if shipping exemptions nvarchar 100 0 ('')
28 ShippingWeight Weight in pounds of all packages (# of ounces of packages included in ShippingWeightOz field below) smallint 4 0 0
29 ShippingPackages Total number of packages to be shipped smallint 2 0 0
30 HandlingCharge Handling Charge added to order money 8 0 0
31 ClientNum A client assigned number for this customer, if applicable to your business practice nvarchar 30 0 ('')
32 CompanyName Name of the company the customer is from, if applicable nvarchar 150 0 ('')
33 Country Billing Country where this order is going to nvarchar 40 0 ('')
34 BAddress3 3rd Line of Billing Address nvarchar 40 0 ('')
35 SAddress3 3rd Line of Shipping Address nvarchar 40 0 ('')
36 SCountry Shipping Country where this order is going to nvarchar 40 0 ('')
37 ShippingWeightOz Weight in ounces of all packages (# of pounds in packages found in ShippingWeight field above) smallint 4 0 0
38 SClientNum Ship To Client Number nvarchar 30 0 ('')
39 SCompany Ship To Company nvarchar 150 0 ('')
40 ShipEmail Ship To Email Address nvarchar 4,000 0 ('')
41 SPhone Ship To Phone Number nvarchar 20 0 ('')
42 SFax Ship To Fax Number nvarchar 20 0 ('')
43 Quantity Item Quantity int 4 1 0
44 ItemID Key to associate product info to Internet Conduits's database. May be used to return product information e.g. inventory to Internet Conduits. int 4 1 0
45 CatalogCode Client Assigned Product/Part Number nvarchar 30 1 ('')
46 ItemOptions Options for a Product, e.g. size, color nvarchar 255 1 ('')
47 ItemName Client Product Name nvarchar 100 1 ('')
48 Price Price of Item money 8 1 0
49 SpecialDescription If item marked as 'Special', the description of the special will appear here nvarchar 150 1 ('')