Daily Update Files

As these daily files are created directly from our database, the headings for each file can be somewhat confusing. Below you will find a simple explanation as to the headings of our daily update files so as to aid you in using them in populating your website with products.

It should also be noted that our comma delimitted files utilize a quotation mark (") as a text qualifier.

Descriptions.csv and Descriptions.xml

These files provide for you a list of our items by our item code followed by the corresponding item description.

Within the files, these columns are headed by "NUMBER", under which you will find our item codes, and "INETFDESC" under which you will find the corresponding description.

StockInfo.csv and StockInfo.xml

This file contains a list of our items by item code, as well as each items name, how many units of that item are available, the weight of each unit, the retail price of each item, the estimated delivery date if the item is out of stock, if the item has been discontinued.

The columns are headed as follows:

  • NUMBER: Provides the item's unique item code
  • DESC1: Provides the items's name
  • UNITS: Quantity in stock
  • UNITWEIGHT: Provides the weight of the item, per unit.
  • PRICE1: Lists the retail price of each item.
  • DELDATE: Lists the estimated arrival date of an item if it is out of stock
  • DISCONT: Indicates if an item has been discontinued. 0 indicates that the item has not been discontinued. 1 indicates that the item has been discontinued. Please note that it is possible for an item to be both in stock and discontinued.
  • INETIMAGE: This is the image path and name for our sytem. You would need to remove the I:\Web\letter\, most times it is the same as the NUMBER unless we use the same image for multiple items.

Departments.csv and Departments.xml

This file provides a full listing of all of our product categories. This includes the departments individual code, the level at which the department is displayed, whether the department is displayed or not, and which department a particular sub department is listd under.

Please note that there is a "blank" field representing a site without departments. It is from this "blank" department that our department model is built.

The columns are headed as follows:

  • NAME: This column provides the name of each department
  • DEPTCODE: This column provides the numerical code used to define each department
  • NLEVEL: This column defines the level at which a department is displayed. For example, no departments is level 0, the first department is level 1, and subdepartments under that department are at level 2.
  • DISPLAY: This column defines whether a department is visible or not. True indicates that a department is visible. False indicates that the department is not visibly listed.
  • UNDER: This column indicatse whether a department is a sub departmetn or not. If it is a subdepartment, it lists which department code it is listed under.

Product-Department.csv and Product-Department.xml

This simple file is intended to work along-side the Departments.csv and Departments.xml files. It lists our products by product code and then provides the corresponding department code.

To this end, the NUMBER column provides the item code while the DEPTCODE column provides the corresponding department code under which that item can be found.