This is the area to upload text files (.txt) of lists of auction items
made by a database program (ie -- Excel, Access, FoxPro etc.) All other
file extensions will be rejected. This is an advanced area, and it might take a
couple of tries to get it down correctly. Read the common problems to avoid on
the right. The effort is worth it! Once you have mastered making your auctions
offline, you will save a lot of time.
 |
The type of file you are uploading is not a text file. Even if you save as a tab or comma separated file,
some programs do not put a .txt extension on the file. Open the file in notepad, and save it as a text file.
|
|
Many spreadsheet programs save your file with the column names in the first row. This row must be removed.
|
|
Some spreadsheet programs like Access will allow line returns in a data record. Each record must be contained
completely within one line, or the upload tool will not know what belongs to what.
|
|
When using a Tab for a separator, HTML that is pasted from an HTML editor also contain tabs. This of
course will cause a record of data to be split incorrectly.
|
|
Quantities should be whole numbers, and prices should NOT include money symbols.
|
|
Some spreadsheet programs add quotation marks around all your data fields, you will need to remove these using the search & replace function of a text editor or wordprocessor before uploading your file. Simply search for " and replace with nothing or a space to clear them from your file.
|
|
The category field must contain a number that represents that category. Contact your site administrator for a list of category numbers.
|
|
|
|
|
|
|
Your file should contain rows of records that are separated by either
comma, pipe (|), or tabs. It does not matter the order it is in, as you will assign the fields to the type
of data it contains after uploading. Your item title and description can be contained in up to 5
different columns. The program will put them together in the order you choose. Bold fields are required.
Category -- a number, matching site category.
Title -- Text, maximum 120 characters.
Title 2
Title 3
Title 4
Title 5
Description -- Text, May contain HTML, but make sure there are no line returns or breaks in this. Final
description will combine up to 5 columns.
Description 2
Description 3
Description 4
Description 5
Image Url 1 -- Text, the URL of an image. Make sure to include http://.
Image Url 2 -- Text, the URL of an image. Make sure to include http://.
Image Url 3 -- Text, the URL of an image. Make sure to include http://.
Image Url 4 -- Text, the URL of an image. Make sure to include http://.
Image Url 5 -- Text, the URL of an image. Make sure to include http://.
Image Url 6 -- Text, the URL of an image. Make sure to include http://.
Quantity -- Whole Number
Estimated Value -- Money field without dollar sign.
Selling Price -- Money field without dollar sign.
Reserve Price -- Money field without dollar sign.
Shipping Terms -- Text. You may also opt later on to include default terms.
Payment Terms -- Text. You may also opt later on to include default terms.
Shipping Amount -- Money field without dollar sign.
Consignor -- Text, 30 characters. Lower case Member ID of the Consignor.
Buy Price -- Money field without dollar sign.
|
|
|
