Chrislands Upload Format
Comma-Delimited Files

Listed in the table below is the field format for comma-delimited (.csv) upload files
Only 3 fields must contain data (Seller ID, Title, and Price); the other fields may contain null values.
34 fields must be present in each upload file, even if the many of the fields contain null values.

Field Sequence	Field Name	Type and (length) of field	Are null values allowed
1	Seller ID (unique ID assigned to each book)	text or number (50)	Null value not allowed
2	Author	text (255)	May be null
3	Title	text (255)	Null value not allowed
4	Illustrator	text (255)	May be null
5	Book condition	text (999)	May be null
6	Book size	text (50)	May be null
7	Jacket conditionn	text (30)	May be null
8	Binding	text (50)	May be null
9	Book type	text (30)	May be null
10	ISBN	text (15)	May be null
11	Publisher	text (255)	May be null
12	Publish place	text (100)	May be null
13	Publish Date	text (50)	May be null
14	Edition	text (150)	May be null
15	Inscription	text (50)	May be null
16	Description	text (65000)	May be null
17	Quantity	integer  (max value = 999)	May be null. If null, default value of 1 assigned
18	Price	numeric(no $ sign)	Null value not allowed
19	Image	text (255)	May be null. If used, must be web address such as http://www.name.com/image.jpg
20	Category 1	text (128)	May be null.  If null, book will be assigned to "Other" category
21	Category 2	text (128)	May be null.   A book can be assigned to multiple categories.
22	Category 3	text (128)	May be null
22	Category 4	text (128)	May be null
24	Category 5	text (128)	May be null
25	Keyword 1	text (2500)	May be null.  Entries in this field will will be included in "Keyword" searches.
26	Keyword 2	text (2500)	May be null
27	Keyword 3	text (2500)	May be null
28	Keyword 4	text (2500)	May be null
29	Keyword 5	text (2500)	May be null
30	Keyword 6	text (2500)	May be null
31	Keyword 7	text (2500)	May be null
32	Keyword 8	text (2500)	May be null
33	Keyword 9	text (2500)	May be null
34	Weight	numeric (no text, such as lbs, kgs)	Optional Field
35	Featured Item	text(15)	Optional Field - If you want an item to apppear as a Featured Item, then enter any letter in this field. If this field is null, then the item will not be listed as a featured item

When uploading by FTP use the following naming conventions to let the server now how you want your upload file processed.

1.  Purge upload.  When processing a purge upload, all of your online listings will be deleted and then replaced with the listings in the purge upload file.  

To initiate a purge upload when uploading by FTP include the string “purge” in the name of the upload file.  Examples

Purge.csv
purge.txt
purge21Aug01.csv

2. Delete upload. When processing a delete upload, only the first field (Seller ID) of each record is read and that corresponding item will be deleted from your online listings.

To initiate a delete upload when uploading by FTP include the string “del” in the name of the upload file. Examples

Del.csv
delete.txt
delete21Aug01.csv

3. Add/Modify upload. New records will be added to the your online listings and if an item has the same item number as an online listing, then the online listing will be updated with the new information.

Any upload file that does not contain “del” or “purge” will be treated as an add/modify upload.