|
Homebase
If you are using Homebase from ABE then you need
to follow these instructions
1/ Start Homebase
2/ On the menu go to File - Import / Export - Export
3/ Ensure that you have the correct export criteria
(i.e. changed from)
4/ Click OK
5/ Name your file "adds.csv" without
quotes
6/ Select "Homebase" as the Save As Type
(You may need to overtype the file extension)
7/ Save your file
8/ Use FTP to upload that file to BookLovers or log
in and use the browser option.
9/ Log into the site and you will be asked whether you
wish to run your updates.
Note. The first file that you send us should be your
complete database of books for sale. That needs to be
done by email and should be in the same format as above.
Please also note that you can zip the file to decrease
the time taken to email it. I recommend WinZIp for that
purpose
BookList
If you are using Booklist from Clique then follow
these instructions
1/ Start Booklist
2/ Click "search" on the menu
3/ Enter your criteria (usually Unsold and date criteria)
4/ Click "search" again
5/ When you have the search results (books found ###)
click "export" on the menu
6/ Select Tilde Delimited for database back up as the
file of type required
7/ Enter "adds" as the file name for unsold
books
8/ Enter "deletes" as the file name for sold
books
9/ Use FTP to upload that file to BookLovers or log
in and use the browser option.
10/ Log into the site and you will be asked whether
you wish to run your updates.
Note. The first file that you send us should be your
complete database of books for sale. That needs to be
done by email and should be in the same format as above.
Please also note that you can zip the file to decrease
the time taken to email it. I recommend WinZip for that
purpose
Access / Custom Systems
Your file structure should be as follows, if
you list at Amazon.co.uk, then you can use the same file for BookLovers.co.uk
as you do there if your field order is as below.
| Field Name |
Comment |
Length / Type |
|
product-id
|
ISBN if known |
25 Chars Text |
|
author
|
|
255 Chars Text
|
|
title
|
|
255 Chars Text |
|
price
|
|
10 Chars Numeric |
|
sku
|
Inventory Number / Unique ID |
25 Chars Text |
|
publisher
|
|
155 Chars Text |
|
pub-date
|
Year of Publication only |
100 Chars Text |
|
binding
|
Hardback / Paperback / DJ |
50 Chars Text |
|
item-condition
|
|
255 Chars Text |
|
quantity
|
Either 1 or 0 |
1 Char (1 = For Sale, 0 = Sold) Text |
|
item-note
|
Other comments |
255 Chars Text |
|
illustrator
|
|
255 Chars Text |
|
condition
|
Book and/or Jacket condition |
255 Chars Text |
|
edition
|
|
255 Chars Text |
|
will-ship-internationally
|
Not used on our system |
Not required |
|
add-delete
|
Not used on our system |
Not required |
|