The data file is in comma separated values (CSV) format. The first line will be column names, and following lines will each be one inventory item. The website software should interpret the file according to the header line; it should not assume that the order of the fields will remain constant. Also, it should not assume that additional columns will not be added in the future. Following is a description of each column:
|
ItKey |
The internal item number from The Edge. |
|
itVendorId |
The internal abbreviation for the supplier of the item. |
|
itVendStyleCode |
The suppliers code for this item. |
|
itRetailPrice |
The full retail price of the item. This might be MSRP, or just your normal starting price. |
|
itCurrentPrice |
This field might be blank. If it has a value, it could be less than retail, and could represent a special sale price, or might be an automatically discounted price due to age. |
|
itImage |
The filename, including extension, but not including any path, for the image file that corresponds to this item. This field could be blank. If there is more than one image file, the filenames should be separated by vertical bars (│). |
|
itStatus |
The status of the item. It could be many values, but for the purpose at hand, I means in-stock and any other value means that, if the item is already on the web site, it should be removed. |
|
itDesc |
The description of the item. |
|
|
Any non-text characters, such as TAB, in any of the above fields will be represented by a tilde (~) followed by a 2-digit hex number. Tildes themselves are also represented by a tilde and two digits. It is up to the website software to interpret this data. |
