Application | Indicates if item should be uploaded to auction or store | 1 for Auction 2 for Store |
AuctionID | Identifies auction to upload to | Number assigned when you create an auction (auction àauction creationà add auction) |
Balance Sheet | Indicates value of portfolio (only used by one client) | Number |
CardNumber | Trading Card Number | Number |
CategoryID | Indicates what category the item should fall under | Number (configure categories under config àconfig global à categories) The categories report on that page will show the ID numbers |
Commission | To be paid to consigners as a percentage | Number (do not include % sign) |
Condition | Condition of the item | Text |
Consigner | Indicated who is consigning the item | ID Number (configured when a consigner is added) Consign à list consigners will show a list of consigner IDs |
Cost | How much was paid to acquire the item | Number (don’t include $ sign) |
Description |
| Text |
EbayPrice |
| Number (don’t include $ sign) |
EstimateHigh | High end estimate of what you think the item will sell for. This can be configured to show on the catalog page if desired | Number (don’t include $ sign) |
EstimateLow | Low end estimage of what you think the item will sell for. This can be configured to show on the catalog page if desired | Number (don’t include $ sign) |
ExternalVendorCategories | Only used if you have external vendors | Number (needs to be configured) |
ExternalVendorTitle |
| Text |
Hidden | If you do not want the item to be shown in the catalog | X for yes N for no |
ImageSize | Indicates the image size in the PRINT catalog | 0 for small 1 for medium 2 for large |
LOACertNum | For authentification records | Number |
LOAGrade |
| Text |
LOAProvidor |
| ID Number (needs to be configured under config àconfig global àLOA) The number to be entered into the spreadsheet is listed beside the LOA name on the config page |
LOAYear |
| Number (the year) |
LocationFieldID | Will indicate where the item is physically stored | ID Number (needs to be configured under config àconfig global àlocations) The ID number listed next to the name of the location field should be entered in spreadsheet |
LocationValue | Will indicate the location an item is physically stored WITHIN the location field (more specific) | ID Number (needs to be configured under config àconfig global àlocations) The ID number listed next to the name of the location value should be entered in spreadsheet |
Lot Number |
| Number |
MetaDescription | For SEO | Text |
MetaKeywords | For SEO | Text (coma delineated) |
MinBid |
| Number (don’t include $ sign) |
Notes |
| Text |
OnEbay | Indicates if the item is on eBay | X for yes N for no |
Page Size | Indicates how much space the item should take up in a print catalog | 1 for full page 2 for ½ page 3 for ¼ page 4 for 1/6 or 1/8 page |
Price | How much the buyer would be required to pay to purchase the item | Number (don’t include $ sign) |
PromoteToEbay | Indicates it the item should be uploaded to eBay | X for yes N for no |
PurchaseDate | Date the item was purchased | Mm/dd/yyyy |
Quantity |
| Number |
ReceivedDate | Date you received the item | Mm/dd/yyyy |
Reference |
| Text |
Reserve | Indicates the price a bid must reach for the item to be awarded to the bidder | Number (don’t include $ sign) |
Sale Price | Indicates a reduced price buyers would be required to pay if items in the store should go on sale | Number (don’t include $ sign) |
Serial number |
| Number |
Set ID | For trading card sets | Number (configured under config à config store à sets) |
ShippingCategoryID | Indicates the size of the item and the associatedshipping charges | Number (configured under config àconfig auction à shipping) |
ShortDescription |
| Text |
SortValue | Used to organize lots within categories | Text (configured under config àconfig global à sort values) |
StatusId | To indicate a certain status of an item | ID Number (configured under config à config global àinventory status) |
Title | Name given to the item | Text |
VendorId |
| ID Number |
VendorPartNumber |
| ID Number |
Weight |
| Number (in pounds) |
Image |
| 1) Either provide a full URL if image is already online 2) Or enter a unique name for each image here. Then upload the images with that EXACT same names to your user upload directory (we will provide you with the login) and move the images via movepictures.aspx. Do not include the extension (i.e. JPG) in the image name in the spreadsheet. |