External Load
Index
Important Message - click here for help
Field Descriptions/Customer 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
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
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 |
|
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 |