Uploading Items to Stamps2Go

Uploading to Stamps2Go

The normal way to list a stamp for sale at Stamps2Go is by clicking "Sell a Stamp" from the main menu, and entering the information about the item for sale. However, if you have numerous items to list, and you already have them stored in some type of database, it may be more convenient to upload your item information in a file.

Stamps2Go allows you to upload item information from a comma-delimited (CSV) file. This is done by selecting "Sell a Stamp" from the main menu at the top of the page, then clicking the "Upload CSV File" button on the item entry screen. You will be asked to provide the name of the file on your computer to upload.

The CSV file format we expect is compatible with, and may be generated by Microsoft Excel and other spreadsheet and database programs. For example, if your stamp listing is entered into an Excel spreadsheet, you could select "Save As" from the Excel "File" menu, and pick "CSV" file as the file type. The rules for this format are as follows:

The file is an ascii text file. The only characters allowed are printable ascii characters, and CR/LF.
Each line of the file contains information about one item for sale. Lines are separated by CR/LF.
Each field (column) in item lines must be separated by a comma.
The first line in the file must contain column headings, as defined below.
Columns may appear in any order, and all required columns must be present.
If a field contains an embedded comma, the entire field should be placed in double quotes.
If a field contains an embedded double quote, it should be immediately preceded by another double quote.

Here are the column descriptions for uploading to Stamps2Go:

Column Name Req'd Max Width Description Allowable Content

Command Yes 1 Upload action to take "A" = add item
"U" = update item
"D" = delete item

SellerID Yes 10 Your Stamps2Go user ID Letters, numbers, underscore.

Ref Yes 8 Your reference number for item Letters, numbers, punctuation.

ListingType Yes 2 2-letter code for Stamps2Go listing type "ST" = Scott-listed stamps
"CV" = covers
"SE" = sets
"SR" = SRS-listed state revenue stamps
"FG" = fish & game
"CD" = cinderellas
"ER" = Scott-listed errors
"OD" = oddities & freaks
"MX" = mixtures
"PH" = postal history

Country Yes None Country name
(see list at right)

Scott Maybe 16 Catalog ID Required for ST, SR, FG, ER, OD listing types.

Year Maybe 4 Year of issue Always provide a 4-digit year. Required for CV, CD, SE, PH listing types.

Denom No 6 Denomination Letters, numbers, punctuation.

Issue Yes 30 Issue/subject description Letters, numbers, punctuation.

Topic No 50 Topic category (see instructions below) Text and colons

ImageURL No 100 URL of image file Any character allowed in URL path.

IsRefImage Yes 3 Is this a reference image (not actual image)
Yes or No, leave blank if no ImageURL

Format No None Item format
(see table below) Must be spelled exactly the same as shown in "Format" dropdown box on item entry screen.

Category No None Item category
(see table below) Must be spelled exactly the same as shown in "Category" dropdown box on item entry screen.

Cover No None Cover type
(see table below) Must be spelled exactly the same as shown in "Cover" dropdown box on item entry screen.

Grade No None Item grade
(see table below) Must be spelled exactly the same as shown in "Grade" dropdown box on item entry screen.

Price Yes 9 Item price (US dollars and cents) Do not include a dollar sign or cents sign. Decimal point may or may not be present.

Qty No 4 Quantity available If included, must be in the range 1 to 99999. If this field is omitted, the quantity defaults to 1.

Comment No 2000 Description of item Letters, numbers, punctuation.

Notes:

Column headings and field entries for Country, Format, Category, Cover, and Grade are NOT case sensitive.
When adding or updating items, all required fields must contain valid data.
When deleting items, all fields may be blank except Command, SellerID and Ref.

Allowable Topics

Our topic list will change from time to time as new categories are added, so we do not present a fixed list of topics here. Instead, you may view the current allowable topics by logging in to Stamps2Go, clicking "Sell a Stamp", and viewing the entries in the "Topic" dropdown box on the entry screen.

When entering the topic category in your CSV file, you must enter the full text of the topic and sub-topics, separated by colons. For example, the topic for a stamp depicting an animal that is not described by a more detailed sub-topic would be "Animals". The topic for a bird that is not described by a more detailed sub-topic would be "Animals:Birds". And the topic for a duck would be "Animals:Birds:Ducks".

Allowable Formats

For ST,CV,FG,CD,ER,OD listing types:

Single Stamp
Horiz Pair
Vert Pair
Coil pair
Coil Gap Pair
Coil Line Pair
Coil Line Gap Pair
Coil Strip
Joint Line Pair
Horiz Gutter Pair
Vert Gutter Pair
Block of 4
Block of 6
Block of 8 or More
Margin Block of 4
Margin Block of 6
Corner Block
Center Block
Center Line Block
Plate Single
Plate Pair
Plate Block of 4
Plate Block of 6 or more
Plate Strip of 3
Plate Strip of 5
Zip Block of 4
Zip Block of 6
Other Block
Strip
Setenant
Margin Strip
Full Sheet
Half Sheet
Quarter Sheet
Pane
Booklet Pane
Complete Booklet
Other

For SE listing type:

Complete Set
Complete Year Set
Setenant Set
Partial Set
Other

For MX listing type:

Kiloware
Packet
All Different
Other

For PH listing type:

Souvenir Sheet
Postal Stationery
Postal History
Other

Allowable Categories

For ST,ER,OD,PH listing types:

MNH
MLH
MH
Unused
Used
Perf Cancel
Cut Cancel
Pre-Cancel
CTO

For SE,MX listing types:

MNH
MLH
MH
Unused
Used
Perf Cancel
Cut Cancel
Pre-Cancel
CTO
Mixed

For FG listing types:

MNH
MLH
MH
Unused
Used
Perf Cancel
Cut Cancel
Pre-Cancel
Artist-signed

For CV listing types:

First Day Cover
Cachet FDC
Event Cover
Usage cover
Other

Allowable Cover Types

For ST,FG,CD,ER,OD,SE,MX listing types

None
Envelope
Cut Square
Postcard
Document
Stationery
Other

For CV listing type:

Envelope
Postcard
Document
Stationery
Other

Allowable Grades (all listing types)

Damaged
Poor
Average
Fine
F-VF
Very fine
Superb
Various

Column Name	Req'd	Max Width	Description	Allowable Content
Command	Yes	1	Upload action to take	"A" = add item "U" = update item "D" = delete item
SellerID	Yes	10	Your Stamps2Go user ID	Letters, numbers, underscore.
Ref	Yes	8	Your reference number for item	Letters, numbers, punctuation.
ListingType	Yes	2	2-letter code for Stamps2Go listing type	"ST" = Scott-listed stamps "CV" = covers "SE" = sets "SR" = SRS-listed state revenue stamps "FG" = fish & game "CD" = cinderellas "ER" = Scott-listed errors "OD" = oddities & freaks "MX" = mixtures "PH" = postal history
Country	Yes	None	Country name (see list at right)
Scott	Maybe	16	Catalog ID	Required for ST, SR, FG, ER, OD listing types.
Year	Maybe	4	Year of issue	Always provide a 4-digit year. Required for CV, CD, SE, PH listing types.
Denom	No	6	Denomination	Letters, numbers, punctuation.
Issue	Yes	30	Issue/subject description	Letters, numbers, punctuation.
Topic	No	50	Topic category (see instructions below)	Text and colons
ImageURL	No	100	URL of image file	Any character allowed in URL path.
IsRefImage	Yes	3	Is this a reference image (not actual image)	Yes or No, leave blank if no ImageURL
Format	No	None	Item format (see table below)	Must be spelled exactly the same as shown in "Format" dropdown box on item entry screen.
Category	No	None	Item category (see table below)	Must be spelled exactly the same as shown in "Category" dropdown box on item entry screen.
Cover	No	None	Cover type (see table below)	Must be spelled exactly the same as shown in "Cover" dropdown box on item entry screen.
Grade	No	None	Item grade (see table below)	Must be spelled exactly the same as shown in "Grade" dropdown box on item entry screen.
Price	Yes	9	Item price (US dollars and cents)	Do not include a dollar sign or cents sign. Decimal point may or may not be present.
Qty	No	4	Quantity available	If included, must be in the range 1 to 99999. If this field is omitted, the quantity defaults to 1.
Comment	No	2000	Description of item	Letters, numbers, punctuation.