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 |
No |
ShippingWeight
|
Number of pounds of an item used with Specified
Carriers (separate field below for ounces, only whole numbers allowed, no
fractions or decimals). If no entry will default to
0. |
[0 – 75] |
4 |
No |
Bundling
|
Determines whether an item delivered by
Specified Carriers is allowed to be put into the same package as
another item or should be shipped separately. 0=Assumed bundled, 1=Shipped
separate from other items, 2=Shipped separate from other items, even multiple
quantities of this item. If no entry will default to
0. |
[0 – 2] |
2 |
No |
| OnSpecial | Whether an item is on Special. 0=Not on Special, 1=On Special (Special does not change price). If no entry will default to 0 | [0 – 1} | 1 | No |
| SpecialDescription | Description of the Item Special, e.g. buy this item and get a free decal. | [Text] | 150 | No |
| SaleType | Whether the Sale Price is a Percent or Absolute Price. Only Percent or Absolute are valid values. | [Text] | 10 | No |
| SalePercent | Sale percentage rate. | [Number] | 4 | No |
| SalePrice | Absolute Sale Price | [Price] | 8 | No |
ShippingTerms
|
Special shipping terms for ShippingType 2 (not used
with Specified Carriers) |
[Text] |
Infinite |
No |
FirstCost
|
Cost for first item to be shipped (ShippingType 1-
not used with Specified Carriers) |
[Price] |
8 |
No |
AddCost
|
Cost for each additional item(s) to be shipped (ShippingType
1 not used with Specified Carriers) |
[Price] |
8 |
No |
InvEnabled
|
Is inventory being used on this item? No = 0, Yes =
1. If no entry will default to
0. |
[0,1] |
1 |
No |
StockQty
|
Amount in stock |
[Number] |
4 |
No |
MinQty
|
Minimum amount allowed |
[Number] |
4 |
No |
StockMessage
|
Message when minimum reached. |
[Number] |
255 |
No |
SpecialPrice
|
Use this when an item doesn't have a price. No = 0,
Yes = 1. If no entry will default to
0. |
[0,1] |
1 |
No |
SpecialPriceText
|
Text displayed instead of price. |
[Text] |
50 |
No |
| ShippingWeightOz | Number of ounces of an item used with Specified Carriers (separate field above for pounds, only whole numbers allowed, no fractions or decimals) |
[0 – 75] |
4 |
No |
| chkRejectQty | Does this item have a minimum quantity?No = 0, Yes = 1. If no entry will default to 0. | [0,1] | 1 | No |
| txtRejectQty | Item minimum quantity. | [Number] | 8 | No |
| chkRejectQtys | Must this item be ordered in multiple quantity amounts? No = 0, Yes = 1. If no entry will default to 0. | [0,1] | 1 | No |
| txtRejectQtys | Item multiple quantity amount. | [Number] | 8 | No |
| inventoryEmailOveride | Email address to send reorder notification. Overrides email address found in Catalog Settings. May be multiple addresses separated by a semi-colon. | [Text] | Infinite | No |
| inventorySend | Only send 1 email when minimum qty is reached for this item. If no entry will default to 0. | [0,1] | 1 | No |