Home of BayLister, an auction listing aid.

Home  |   Support  |   Download  |   Donate  

"eBay and the eBay Logo are trademarks of eBay Inc." BayLister Database Field Definitions.

These are the current field definitions for the BayLister database as of October,15,2008. We occassionally add new fields as we add features or improvements.

 AucFmt      Auction, FixedPriceItem, StoresFixedPrice, RealEstateAd
 Title       55 characters maximum, per eBay
 SubTitle    (same as above)
 Notes       Any text (only shows in "MyEbay")
 Cat1        Must be the actual leaf category number [integer]
 PreType     ISBN, UPC, or EAN (1 0f these to define the string in PreId)
 PreID       The actual ISBN, UPC, or EAN string
 StoCat1	  
 PicUrl      URL path for all pictures in listing, "eg. www.me.com/pics/"  
 EpsPic      Set to true if you want eBay to host your picture. [boolean]
 AutoPay     True if AutoPay is required. [boolean]
 BestOff     True if you desire Best Offer to be set. [boolean]
 Quant       Number of items for sale. [integer] 
 LotSz       Number of items in a lot. [integer] 
 Duration    Length of Auction. [integer] 
 StartPrice  currency[numeric] eg. 2.25 (no dollar sign) 
 reserve     currency[numeric] eg. 2.00 (no dollar sign) 
 BIN         currency[numeric] eg. 3.25 (no dollar sign) 
 PrivAuc     Set to True for a Private Auction [boolean]
 CtrStyle    BasicStyle, GreenLED,  Hidden,  HonestyStyle, NoHitCounter,
             None (same as NoHitCounter), Andale, Vendio [text] 
 PayInstruct [text] 
 Insure      NotOffered, Optional, Required, IncludedInShippingHandling [text] 
 InsureIntl  (same as above) [text} 
 InsureFee      currency[numeric] eg. 2.00 (no dollar sign) 
 InsureIntlFee  currency[numeric] eg. 2.00 (no dollar sign) 
 PPUse       Set to true if allowing PayPal [boolean]
 MO          Set to true if allowing Money Order [boolean]
 Pchk        Set to true if allowing Personel check [boolean]
 VisaMC      Set to true if you have and use a Visa or Mastercard Merchant Acct [boolean]
 Amex        Set to true if you have and use an AMEX Merchant Acct [boolean]
 Discover    Set to true if you have and use a Discover Merchant Acct [boolean]
 COD         Set to true if you allow Collect On Delivery (COD) [boolean]
 PayOther    Set to true if you have other payment types (declare in description) [boolean]
 Escrow      Set to true if you allow Escrow [boolean]
 Featured    Set to true to pay extra for a Featured listing [boolean]
 Bold        Set to true to select a Bold listing [boolean]
 Highlight   Set to true to select a Highlighted Listing [boolean]
 Border      Set to true to select a Border for your listing [boolean]
 ShipType    Flat or Calculated [text] 
 ShipIntlType  Flat or Calculated [text] 
 ShipPkg     See the drop-down, Package, in BayLister for allowable text strings [text] 
 ShipWW      See the drop-down, Ship-To, in BayLister for allowable text strings [text] 
 ShipLbs     [integer] 
 ShipOz      [integer] 
 PkgHt       [integer] 
 PkgLen      [integer] 
 PkgWid      [integer] 
 ShipZip     5 character Zip code [integer] 
 SandH       Shipping and Handling, currency[numeric] eg. 2.00 (no dollar sign) 
 SandHIntl   (ditto SandH for International) 
 ShipFlat    Fixed Shipping cost for domestic option 1, currency [numeric]  
 ShipFlat2   Fixed Shipping cost for domestic option 2, currency [numeric] 
 ShipFlat3   Fixed Shipping cost for domestic option 3, currency [numeric] 
 ShipIntlFlat   (ditto ShipFlat for International) 
 ShipIntlFlat2  (ditto ShipFlat2 for International) 
 ShipIntlFlat3  (ditto ShipFlat3 for International) 
 ShipAdtl    Additional domestic shipping cost for additional units of the same item, currency 
 ShipAdtl2   Additional domestic shipping2 cost for additional units of the same item, currency 
 ShipAdtl3   Additional domestic shipping3 cost for additional units of the same item, currency 
 ShipIntlAdtl   (ditto ShipAdtl for International)
 ShipIntlAdtl2  (ditto ShipAdtl2 for International) 
 ShipIntlAdtl3  (ditto ShipAdtl2 for International) 
 ImmedPay    Set to true if Immediate Payment is required. [boolean]
 ShipDiscount  Set to true if a shipping discount is provided. [boolean]
 OrigCost    currency[numeric] eg. 2.00 (no dollar sign) 
 PicDisk     Location of pictures on your local hard disk (directory path) [text] 
 SinglePic   File name of picture on PicDisk [text] 
 Ship1       See the Shipping Services drop-down 1, for allowable text strings [text] 
 Ship2       See the Shipping Services drop-down 2, for allowable text strings [text] 
 Ship3       See the Shipping Services drop-down 3, for allowable text strings [text] 
 ShipIntl1   See the Shipping Services International drop-down 1, for allowable text strings [text] 
 ShipIntl2   See the Shipping Services International drop-down 2, for allowable text strings [text] 
 ShipIntl3   See the Shipping Services International drop-down 3, for allowable text strings [text] 
 ShipCtys1   See the allowable countries in the shipping section.  
 ShipCtys2   See the allowable countries in the shipping section.
 ShipCtys3   See the allowable countries in the shipping section.