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. "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 emtpy columns come before.

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

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.

Start Your Journey With ChrisLands Today!

If you have a business and that business sells products, you need an ecommerce website.