* Please Note: You can also use this format for a Comma Separated Values (CSV) file.
Listed in the table below is the file format defined by ChrisLands for uploading your inventory. ChrisLands must know if you choose to use this format so we can properly configure your store.
Only 3 fields must contain data (Seller ID, Title, and Price); the other fields may contain null values. "May be null" means empty, no data entered.
All 35 fields must be present in each upload file, even if many of the fields are empty. For instance, Price must be in the 18th column even if empty columns come before.
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 condition
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
23
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
Optional Field
35
Featured Item
text(15)
Optional Field - If you want an item to appear 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. This purge file should contain all your current listings.
To initiate a purge upload when uploading by FTP include the string "purge" in the name of the upload file. Examples
Purge.txt
purge.tab
purge21Aug01.txt
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.txt
delete.txt
delete21Aug01.tab
3. Add/Modify upload. New records are added to 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.
If you have a business and that business sells products, you need an ecommerce website.