External Load 

Index

Important Message - click here for help

Field Descriptions/Customer Data - click here for help

Field Descriptions/Item Data - click here for help

This feature allows you to load a volume of product detail or customer information by providing the required fields in a comma-delimited file. The file can then be uploaded to our server and entered in our database.  This feature will be useful if you currently have a database of product or customer data and do not want to manually enter each item or customer by using the graphical interface.  When you click the Customer or Item template you will be given a file layout in an Excel spreadsheet format. You will need to map your field names to the field names provided in the templates. Save the file to your hard drive or a disk. Be sure your file name has no spaces or characters other than letters and numbers or it will error.

When you are ready to upload the file, simply click on the File Upload button for Customer or Item data, locate your file using the Browse button and then click the 'Use this file and begin uploading the data' button.

After the file has been uploaded and the data entered, you will receive a results screen itemizing each transaction and whether it was updated successfully or if it failed. If there is an error, the message will describe the problem. If the error volume is small, you can then enter the corrected data manually. If the whole file or a major portion of the file failed, you can make the necessary corrections and reload the file.

 Important Message! Things to take note of:

·        Field names should remain in the file that you upload.  Our system will look for the field names and will assume the first line of data in your comma-delimited file is field names.

·        In the table below, there are descriptions of each field, the data format and if the field is required or not. If the field is not required, then blanks are acceptable. You must adhere to the file format and the data type to avoid failed entries.

·        Before sending the first file, please notify Internet Conduits at 414-727-4033 or by email to support@InternetConduits.com    

Field Descriptions

Customer Data

Field Name

Field Description

Data Type

Character Length

Required

BName

Billing Name

[Text]

40

Yes

BAddress1

Billing Address

[Text]

40

No

BAddress2

Billing Address 2 (Apartment #…etc)

[Text]

40

No

BCity

Billing City

[Text]

25

No

BState

Billing State (must be spelled out)

[Text]

40

No

BZip

Billing Zip Code

[Text]

15

No

Phone

Phone Number

[Text]

20

No

Fax Fax Number 

[Text]

20

No

 EMail

Email address

[Text]

4,000

No

SName

Shipping Name, if different from Billing

[Text]

40

No

SAddress1

Shipping Address 1, if different from Billing

[Text]

40

No

SAddress2 

Shipping Address 2, if different from Billing

[Text]

40

No

SCity

Shipping City, if different from Billing

[Text]

25

No

SState

Shipping State, if different from Billing (must be spelled out)

[Text]

40

No

SZip

Shipping Zip, if different from Billing

[Text]

15

No

Discount

Percent Discount for this customer on total order

[0 – 100]

4

No

NoTax

Is this customer Tax Exempt? No = 0, Yes = 1 If no entry will default to 0

[0,1]

1

No

NoShipping Is this customer Shipping Exempt? No = 0, Yes = 1 If no entry will default to 0

[0,1]

1

No

SpecCustShipping Special Shipping Instructions for this Customer [Text] Infinite No

LogonName

Logon Name, must be unique for each customer

[Text]

30

No

LogonPassword 

Logon Password

[Text]

30

No

InvoicePassword 

Invoice Password

[Text]

30

No

PoNo

Purchase Order Number

[Text]

30

No

ClientNum

Client Number

[Text]

30

No

CompanyName

Company Name on order.

[Text]

150

No

Country

Billing Country (must be supported by Internet Conduits and spelled out)*

[Text]

40

No

SCountry Shipping Country, if different from Billing (must be supported by Internet Conduits and spelled out)*

[Text]

40

No

BAddress3

Billing Address 3 (Apartment #…etc)

[Text]

40

No

SAddress3

Shipping Address 3, if different from Billing

[Text]

40

No

SClientNum

Shipping Client Number

[Text]

30

No

SCompany

Name of Ship To Company

[Text]

150

No

ShipEmail

Ship To Email address

[Text]

4,000

No

SPhone

Ship To Phone Number

[Text]

20

No

SFax Ship To Fax Number 

[Text]

20

No

* Countries and spelling supported by Internet Conduits - Australia, België, Brasil, Canada, Chile, Danmark, Deutschland, Eire, England, España, France, Greek, Italia, Luxembourg, Luxemburg, Mexico, Nederland, Norge, Österreich, Perú, Suid Afrika, Sverige, United States, Zimbabwe

Item Data

Field Name

Field Description

Data Type

Character Length

Required

CategoryNum

Category Number – found in Product Categories option in your catalog.

[Number]

4

Yes

CatalogCode

Product Code

[Text]

80

Yes

ItemName

Product Name

[Text]

150

Yes

ItemDescription

Product Description

[Text]

Infinite

No

ItemManufacturer

Manufacturer

[Text]

150

No

MultiplePricing

Does this item have a multiple pricing structure? No = 0, Yes = 1. If no entry will default to 0

[0,1]

1

No

Quantity1

Quantity break #1

[Number]

4

No

Price1

Price #1 (the only price for non-multiple pricing items).

[Price]

8

No

Quantity2

Quantity break #2

[Number]

4

No

Price2

Price #2

[Price]

8

No

Quantity3

Quantity break #3

[Number]

4

No

Price3

Price #3

[Price]

8

No

Quantity4

Quantity break #4

[Number]

4

No

Price4

Price #4

[Price]

8

No

Price5

Price #5

[Price]

8

No

ShippingType

0-no override of overall shipping choice, 1-Use specified ShippingFirstCost / ShippingAddCost, 2-Use ShippingT erms (not used with Specified Carriers). If no entry will default to 0

[0, 1, 2]

2