Tab-Delimited File Format
* 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. "Optional" 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 # | Field Name | Type (length) | Required |
|---|---|---|---|
|
1 |
Seller ID (unique ID assigned to each book) |
text or number (50) |
Required |
|
2 |
Author |
text (255) |
Optional |
|
3 |
Title |
text (255) |
Required |
|
4 |
Illustrator |
text (255) |
Optional |
|
5 |
Book condition |
text (999) |
Optional |
|
6 |
Book size |
text (50) |
Optional |
|
7 |
Jacket condition |
text (30) |
Optional |
|
8 |
Binding |
text (50) |
Optional |
|
9 |
Book type |
text (30) |
Optional |
|
10 |
ISBN |
text (15) |
Optional |
|
11 |
Publisher |
text (255) |
Optional |
|
12 |
Publish place |
text (100) |
Optional |
|
13 |
Publish Date |
text (50) |
Optional |
|
14 |
Edition |
text (150) |
Optional |
|
15 |
Inscription |
text (50) |
Optional |
|
16 |
Description |
text (65000) |
Optional |
|
17 |
Quantity |
integer (max value = 999) |
Optional. If null, default value of 1 assigned |
|
18 |
Price |
numeric (no $ sign) |
Required |
|
19 |
Image |
text (255) |
Optional. If used, must be web address such as http://www.name.com/image.jpg |
|
20 |
Category 1 |
text (128) |
Optional. If null, book will be assigned to "Other" category |
|
21 |
Category 2 |
text (128) |
Optional. A book can be assigned to multiple categories. |
|
22 |
Category 3 |
text (128) |
Optional |
|
23 |
Category 4 |
text (128) |
Optional |
|
24 |
Category 5 |
text (128) |
Optional |
|
25 |
Keyword 1 |
text (2500) |
Optional. Entries in this field will will be included in "Keyword" searches. |
|
26 |
Keyword 2 |
text (2500) |
Optional |
|
27 |
Keyword 3 |
text (2500) |
Optional |
|
28 |
Keyword 4 |
text (2500) |
Optional |
|
29 |
Keyword 5 |
text (2500) |
Optional |
|
30 |
Keyword 6 |
text (2500) |
Optional |
|
31 |
Keyword 7 |
text (2500) |
Optional |
|
32 |
Keyword 8 |
text (2500) |
Optional |
|
33 |
Keyword 9 |
text (2500) |
Optional |
|
34 |
Weight |
numeric |
Optional |
|
35 |
Featured Item |
text(15) |
Optional If you want an item to appear as a Featured Item, then enter any letter in this field. If this field is empty, then the item will not be listed as a featured item |
When uploading by FTP use the following naming conventions to let the server know how you want your upload file processed.
1. Purge upload: Deletes all current listings and replaces them with the purge file content. The file must contain all current listings.
Include the word "purge" in the filename:
- Purge.txt
- purge.tab
- purge21Aug01.txt
2. Delete upload: Deletes listings based on Seller ID only (first field).
Include the word "del" in the filename:
- Del.txt
- delete.txt
- delete21Aug01.tab
3. Add/Modify upload: Adds new listings or updates existing ones based on Seller ID. If the filename doesn't contain "purge" or "del", it's treated as Add/Modify.